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
kolezko [41]
3 years ago
8

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:
lana66690 [7]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
What do the underlying values in your mission statement tell you?
wariber [46]
A should be your answer
7 0
3 years ago
Read 2 more answers
If a firm enjoys economies of scale up to a certain output​ level, and cost then increases proportionally with​ output, what can
Len [333]

Answer:

D. decreases initially and then is horizontal.

Explanation:

A horizontal long run average cost curve reflects increase in cost proportionate to output, so the firm's long run average cost curve will fall initially and then become horizontal.

8 0
2 years ago
find the future value of an ordinary annuity of $60 paid at the end of each quarter for 3 years, if interest is earned at a rate
max2010maxim [7]

The future value of an ordinary annuity of $60 paid at the end of each quarter for 3 years, if interest is earned at a rate of 4%, compounded quarterly will be 907.2$

<h3>What is Compounding?</h3>

Compounding is the method through which interest is added to both the principle balance already in place and the interest that has already been paid. Thus, compounding can be thought of as interest on interest, with the result that returns on interest are magnified over time, or the so-called "magic of compounding." After a year, you would receive $10 in interest if you deposited $1,000 into an account with a 1% annual interest rate. Compound interest allowed you to earn 1 percent on $1,010 in Year Two, which amounted to $10.10 in interest payments for the year.

Hence, The future value of an ordinary annuity of $60 paid at the end of each quarter for 3 years, if interest is earned at a rate of 4%, compounded quarterly will be 907.2$

To learn more about compounding click,

brainly.com/question/24274034

#SPJ4

7 0
1 year ago
g Which of the following is true about T accounts? a.The left side of a T account is called the credit side. b.The right side of
svp [43]

Answer:

cl i think the answer is A

6 0
3 years ago
Andrew initially worked with a travel website for few months and then became self-employed by starting a martial arts school, wh
Romashka [77]

Answer:

A. Volatility

Explanation:

Volatility refers to high level of fluctuations with little or no consistency. It also refers to the variation in an activity with no constancy.

In the given case, Andrew keeps on swapping jobs within a short duration of time, and in varied fields of little similarity. This conveys a high degree of volatility in Andrew's work habits since he is unable to stick to one job or a field of job.

The changes in his employment structure reveal a pattern of high level of deviations, fluctuations referred to as Volatility.

5 0
3 years ago
Other questions:
  • During January, Luxury Cruise Lines incurs employee salaries of $1.1 million. Withholdings in January are $84,150 for the employ
    12·1 answer
  • If the elasticity of demand for a company’s product is estimated to be 1.72, what would you advise the company to do if their ob
    14·1 answer
  • SpeakEasy, a U.S. software company that specializes in voice-recognition software, wishes to rapidly enter the growing technical
    6·1 answer
  • At the beginning of the year, Kullerud Manufacturing had a credit balance in its allowance for doubtful accounts of $10,670, and
    5·1 answer
  • 1. _______ refers to care of a child in someone else's home. A. Nursery school B. Family child care C. In-home care D. Home chil
    10·2 answers
  • Torres Company uses the gross method and a perpetual inventory system. Assuming the following entries, compute the amount that T
    9·1 answer
  • A popular cartoon channel on television ran a holiday feature on the best and worst high-tech gifts for children. in the feature
    8·1 answer
  • Use information from the Washington Post article "Why We've Been Hugely Underestimating the Overfishing of the Oceans" to determ
    5·1 answer
  • Why is silk smooth ? A long thin fibers B genetic engineering C being harvested in the wild D being made by worms
    9·2 answers
  • Theoretically high taxes slow the economy because
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!