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
Most CLEP exams correspond to blank college courses
Kamila [148]
True Because they have preperations for your tests
8 0
3 years ago
Why do consumer advocates advise against using alternative financial services?.
spayn [35]

Consumer advocates advise against using alternative financial services because of the high cost that's associated with the loans and other services.

<h3>What is a financial service?</h3>

It should be noted that a financial service simply means a wide range of activities such as banking, insurance and investing.

In this case, consumer advocates advise against using alternative financial services because of the high cost that's associated with the loans and other services.

Learn more about financial services on:

brainly.com/question/1357912

7 0
2 years ago
During the past six months, Ben sold goods that cost $43,500, his
cupoosta [38]

Answer:

for this problem the answer would be A. 3.08

Explanation:

Add the expenses and freight (3,500+1,750)

Subtract that from 43,500 (43,500-5250 which equals 38,250). Divide 38,250 by 12,400.

38,250÷12,400=3.08

6 0
3 years ago
Which of the following is not true regarding Depreciation? Group of answer choices Depreciation allocates the cost of a fixed as
Mariulka [41]

Answer: Depreciation expense reflects the decrease in market value each year.

Explanation:

Depreciation is the decrease in the value of an asset due to the passage of time. Overtime, the value of machineries reduce as a result of usage. Depreciation is therefore the reduction in the value of assets. Depreciation is also the method used tin reallocating the cost of a tangible assets over its useful life span. Firms depreciate assets for accounting and tax purposes. The reduction in the value of an asset has am effect on the balance sheet of an entity.

The answer to the question is the second option. Depreciation does not have anything to do with the market value. Other options are correct except for the second option which states that depreciation expense reflects the decrease in market value each year.

8 0
3 years ago
Read 2 more answers
Text written for advertising and marketing campaigns is referred to as o content. context O copy o collateral​
melisa1 [442]

Answer:

always be it and never fail

Explanation:

5 0
3 years ago
Other questions:
  • Carrie noticed at work that Chris and Bucky kept asking her advice on office procedures. Soon, she began to see herself as compe
    15·1 answer
  • Mary is a new supervisor working with a preexisting staff that has resisted many of the new policies she has put into place. Mar
    5·1 answer
  • When selecting the best alternative in a cost-benefit analysis, what are the issues to be considered?
    5·1 answer
  • What is the economic definition of​ utility? Utility is
    12·1 answer
  • Harpeth Valley Water District has a bond outstanding with a coupon rate of 3.55 percent and semiannual payments. The bond mature
    6·1 answer
  • A stock is expected to return 11% in a normal economy, 19% if the economy booms, and lose 8% if the economy moves into a recessi
    5·1 answer
  • Someone help me on some marketing questions
    8·1 answer
  • &amp;Isquo The long coastline of India provides it a strategic location &amp;rsquo. Explan​
    9·1 answer
  • The American Opportunity tax credit:_____. A. is 50% of the first $1,200 of tuition and fees paid and 100% of the next $1,200. B
    13·1 answer
  • 1. Small Producer is heavily dependent on Massive Mart for product sales. When Massive Mart aggressively negotiates lower wholes
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!