1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
kodGreya [7K]
3 years ago
15

Suppose that we want the number of male employees in each department making more than $30,000, rather than all employees (as in

Exer- cise 7.5a). Can we specify this query in SQL? Why or why not?
Business
1 answer:
DanielleElmas [232]3 years ago
7 0

Answer:

The query may still be specified in SQL by using a nested query as follows (not all

implementations may support this type of query):

SELECT DNAME, COUNT (*)

FROM DEPARTMENT, EMPLOYEE

WHERE DNUMBER=DNO AND SEX='M' AND DNO IN ( SELECT DNO

FROM EMPLOYEE

GROUP BY DNO

HAVING AVG (SALARY) > 30000 )

GROUP BY DNAME;

Explanation:

You might be interested in
On january 1, year 2, kincaid company's accounts receivable and the allowance for doubtful accounts carried balances of $31,000
Gala2k [10]

Answer:

$27,725

Explanation:

Given that,

kincaid company's accounts receivable = $31,000

Allowance for doubtful accounts at January 1 = $500

Wrote off receivables as uncollectible = $550

1% of credit sales

cash collections of receivables = $74,550

Accounts receivable:

= Accounts receivable at January 1 + Credit sales - Wrote off receivables as uncollectible - Cash collection of receivables

= $31,000 + $72,500 - $550 - $74,550

= $28,400

Accounts for Doubtful Accounts:

= Allowance for doubtful accounts at January 1 - Wrote off receivables as uncollectible + 1% of credit sales

= $500 - $550 + (0.01 × $72500)

= $500 - $550 + $725

= $675

Net realizable value of receivables:

= Accounts receivable - Accounts for Doubtful Accounts

= $28,400 - $675

= $27,725

Therefore, the net realizable value of receivables appearing on kincaid's year 2 balance sheet will amount to $27,725.

3 0
3 years ago
Choose the correct category for the items from Sun Company's perspective.
olga nikolaevna [1]

Answer:

a. Land purchased by Sun Company from a local finance company

1) REAL ASSETS, the land exists as a physical asset regardless of the company's transaction.

b. Sun Company's administration building, which houses the finance department

1) REAL ASSETS, the building exists as a physical asset regardless of the company's transaction.

c. Sun Company's inventories of raw materials

1) REAL ASSETS, the inventories exists as a physical asset regardless of the company's transaction.

d. Accounts receivable: money owed to Sun Company by other companies who have purchased products on credits

2) FINANCIAL ASSETS, accounts receivable is a financial concept, not a physical asset

e. Sun Company's corporate checking accounts

2) FINANCIAL ASSETS, checks is a financial concept that represent money, not a physical asset

3 0
3 years ago
Adrian Atwood, a senior manager at MNC, spends a lot of his time assigning group members to particular tasks and scheduling thei
Triss [41]

Answer:

According to the Ohio state studies , we can say that the Adrian as leader is high in initiating structure.

Explanation:

Initiating structure can be defined as the particular degree to which a leader would define his or her role and also specify and organize the role of employees too, in order to achieve the organizations goals.

Adrian is also doing the same thing here, as she has given a lot of time in assigning employees their particular tasks and scheduling their work , in such a way that goals are achieved.

3 0
3 years ago
Student loans, car loans, and housing loans are good examples of
vivado [14]
Long term liabilities 
3 0
3 years ago
Prepare a direct materials purchasing plan for January, February, and March, based on the following facts. Lana Gonzales owns a
larisa [96]

Answer:

January cost $702,200

February cost $812,200

March cost $950,400

Total Purchase cost    

Particulars                     January February  March

Purchase cost of blades $ 207,200.00 $ 227,200.00 $ 230,400.00

Purchase cost of motor $ 495,000.00 $ 585,000.00 $ 720,000.00

                                        $ 702,200.00 $ 812,200.00 $ 950,400.00

 

Explanation:

R.M budget - blades    

Particulars  January February March April

Planned production  11000 13000 16000 12000

Blades req. per unit  4          4                 4                      4

Material req. for prod. 44000 52000 64000 48000

Add: Desired ending inventory 20800 25600 19200 0

Less: Beginning inventory  13000 20800 25600

Net units of blades req. 51800 56800 57600

Cost per blade  $             4.00 $             4.00 $             4.00

Purchase cost of blades $ 207,200.00 $ 227,200.00 $ 230,400.00

R.M budget - motor    

Particulars  January February March April

Planned production  11000 13000 16000 12000

Motor req. per unit  1 1 1 1

Material req. for prod. 11000 13000 16000 12000

Cost per motor  $           45.00 $           45.00 $           45.00

Purchase cost of motor $ 495,000.00 $ 585,000.00 $ 720,000.00

6 0
4 years ago
Other questions:
  • Aiden is designing a blog that will allow many company employees and executives to share company news with both the general publ
    15·1 answer
  • One of the advantages of having a savings account is that the money can be used for emergency purposes, whereas money in bonds,
    12·2 answers
  • Suppose the local pharmacy charges different prices to senior citizens than it charges to younger customers. The pharmacy should
    12·1 answer
  • A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and co
    6·1 answer
  • Trade between countries leads to A. reduced specialization. B. high unemployment in both countries. C. higher product prices. D.
    12·2 answers
  • ________ can track customer satisfaction directly, measure repurchase intention and also gauge a consumer's willingness to recom
    6·1 answer
  • The date on which cash dividends are paid is the a.last day of the fiscal year-end. b.date of record. c.date of declaration. d.d
    9·1 answer
  • At the luxury hotel in miami, florida, three hotel employees serve the needs of each guest. in every room, a guest can summon a
    15·1 answer
  • Sales at a fast-food restaurant average $6,000 per day. The restaurant decided to introduce an advertising campaign to increase
    15·1 answer
  • A bank has written a call option on one stock and a put option on another stock. For the first option the stock price is 50, the
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!