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
Select the answer that best describes why the return on investment (ROI) for higher education is high even thought the cost of c
LekaFEV [45]
The correct answer for this question is this one: "B. You have the potential to earn less money in the future when you continue your education past college."

The return on investment (ROI) for higher education is high even thought the cost of college is increasing. So, <em>you have the potential to earn less money in the future when you continue your education past college.</em>
Hope this helps answer your question and have a nice day ahead.
5 0
3 years ago
Floor drains are rapidly becoming extinct in the United States because they: A) Cause slips and trips B) Are too expensive to in
uranmaximum [27]

I believe the answer is D

7 0
4 years ago
"In the context of goal-setting theory, _____ is information about the quality or quantity of past performance and indicates whe
Bad White [126]

Answer: performance feedback

Explanation: Feedback on performance is a process of communication. It should be continuous as improvements are made on the basis of information exchanged between the manager and the subordinates. Regular follow-up dialogue should be in place to determine success.

Feedback is structured to see where things go right and where they go wrong. This suggests that leaders may need to be vigilant while they develop new behaviors and conquer the learning curves of new skills.

6 0
3 years ago
Jeanie realizes that her values differ significantly from some of her younger subordinates. what should jeanie do to understand
m_a_m_a [10]
<span>Seek out others' points of view and perspectives</span>
5 0
4 years ago
A minimum acceptable rate of return for an investment decision is called the: Multiple Choice Internal rate of return. Average r
spayn [35]

Answer:

Hurdle rate of return.

Explanation:

A hurdle rate can be regarded as minimum rate of return that is been required by an investor or manager

on a particular project or investment.

The hurdle rate gives the description of the appropriate compensation as regards level of risk present. There are

higher hurdle rates associated with riskier projects.

It should be noted that A minimum acceptable rate of return for an investment decision is called the Hurdle rate of return.

6 0
3 years ago
Other questions:
  • Financial educators often recommend that individuals should:
    8·1 answer
  • True or false: economies of scale exist when expansion of the scale of production causes total production costs to increase more
    10·1 answer
  • Let the equation c = 2.32 n + 34,180 represent the cost of raising a child, c, on an income, n. if the corlone family has an inc
    7·1 answer
  • Nubela Manufacturing is considering two alternative investment proposals with the following​ data: Proposal X Proposal Y Investm
    13·1 answer
  • The journal entry to close income summary when there is a net income is (a) debit sales; credit income summary. (b) debit owner'
    6·1 answer
  • The following logo is present on the letterhead of an organization. Which category of communication does this involve?
    9·2 answers
  • There are more than two types of bachelors’ degrees<br><br> true or false?
    9·1 answer
  • Becky Shelton, a teacher at Kemp Middle School, is in charge of ordering the T-shirts to be sold for the school’s annual fund-ra
    14·1 answer
  • Each of two stocks, A and B, is expected to pay a dividend of $7 in the upcoming year. The expected growth rate of dividends is
    6·1 answer
  • Assume that both the demand curve and the supply curve for DVD players shift to the left but the demand curve shifts more than t
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!