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
Which chart is best used to show the results of a class survey with 4 field trip options?
Nimfa-mama [501]
C. Bar chart , It’s a better visual to see the different votes the classmates chose for their 4 field trip options.
7 0
3 years ago
Read 2 more answers
What environmental advantages would there be in having fewer transactions?
ra1l [238]

Answer:

Less Of an Imcome

Explanation:

4 0
2 years ago
Income is one factor used in determining whether or not a job is middle class, and the other is?
torisob [31]

Income is one factor used in determining whether or not a job is middle class, and the other is the nature of the work.

In the United States, 50% of people live in the middle class, according to the most recent Pew Research Center survey from 2021. This is a reflection of the middle class's longer-term downward trend over the previous five decades.

According to a recent Pew research, the majority of Americans were not middle class for the first time since at least the 1960s.

Just 50% of adult Americans in America lived in middle-class households in 2021, compared to 54% in 2001, 59% in 1981, and 61% in 1971.

Both the middle class's demographic share and its part of the income pie have been declining.

To learn more about Pew Research Center here

brainly.com/question/11363612

#SPJ4

5 0
1 year ago
The offeror may _____ the offer at any time prior to acceptance.
ivanzaharov [21]

Answer:

The offeror may retract the offer at any time prior to acceptance.

Most likely the offeror was able to get a better deal somewhere else, which allows the offeror to retract the offer. However, if they had already made a deal, the offeror would have broken the deal, which may result in action.

~

8 0
2 years ago
The definition of environmentalism is_____.
qwelly [4]

Answer:

C

Explanation:

because of the word "environmentalism" which gives meaning and purpose to the term as a group or movement.

8 0
2 years ago
Other questions:
  • Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit
    11·1 answer
  • How do you start a business in America?
    11·1 answer
  • g For a period during which the quantity of inventory at the end was smaller than that at the beginning, income from operations
    6·1 answer
  • Southern Food Service operates six restaurants in the Atlanta area. The company pays rent of $20,000 per year for each shop. The
    11·1 answer
  • You know about computer security, ethnics and privacy
    9·1 answer
  • The Sugar Sweet Company will choose from two companies to transport its sugar to market. The first company charges $3995 to rent
    12·1 answer
  • If a computer store dumps waste behind its building in violation of local, state, or federal environmental regulations, the resu
    8·1 answer
  • Determine which statement about the absolute value of the price elasticity of demand is correct. The price elasticity of demand
    11·1 answer
  • Polly secured a good grade with a 4 GPA in her admission test. However, she was denied admission by a management school. Hence,
    5·1 answer
  • Parks Corporation is considering an investment proposal in which a working capital investment of $10,000 would be required. The
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!