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
You and your spouse are in good health and have reasonably secure jobs. Each of you makes about $40,000 annually. You own a home
chubhunter [2.5K]

Answer:

$63,000

Explanation:

One of the four methods of determining insurance if the DINK method which means Double income with no kids.

To estimate the value of the insurance using this method , the sum of  , mortgage , car loans and personal debt is divided by two and added to the funeral expenses

Mortgage - 100,000

Car loan - 11,000

Personal debt - 2000

Credit card - 3000

Total = 116,000

Insurance = (116,000/2) = 58,000

Funeral expenses - 5,000

=63,000

5 0
2 years ago
Good designs offer users as many alternatives as possible <br> a. True <br> b. False
Arada [10]
The answer to is
b. False

Good designs or more specifically, good designers should prepare multiple design choices that users can choose from. People have different tastes and sense of style. A designer should not impose his own preference and provide different perspectives for the users.<span />
3 0
3 years ago
How do you get a Monthly budget spend down
Pie
You can also save $3 a day. At the end of a 30 day month, you’ll have $60.
3 0
2 years ago
The secret to effective sales is to have a
melamori03 [73]

Answer:

Unique selling proposition (USP)

Explanation:

USP stands for Unique selling proposition, which is defined as the concept of marketing first, proposed as a theory for explaining a pattern in a successful campaigns of advertising.

It defines or means that such kind of campaigns should be made unique or distinctive propositions to the customer or clients in order to convinced them for switching or shifting the brands.

So, the secret for having a effectives sales, to have a USP (Unique Selling Propositions).

5 0
3 years ago
A company's beginning Work in Process inventory consisted of 37,000 units that were 90% complete with respect to direct labor. A
pychu [463]

Answer:

128,000 units

Explanation:

The calculation of the equivalent units of production using the weighted average method is given below:

= Total units of finished goods × completion percentage + ending work in process units × completion percentage

= 107,000 units × 100% + 42,000 units × 50%

= 107,000 units + 21,000 units

= 128,000 units

Hence, the equivalent units of production of direct labor is 128,000 units.

8 0
3 years ago
Other questions:
  • A situation that arises when all alternative choices or behaviors have been deemed undesirable because of the potentially negati
    15·1 answer
  • Which HCPCS level II codes allow suppliers to begin billing immediately for a service or item as soon as it is allowed to be mar
    9·1 answer
  • Explain Labour turnover
    8·1 answer
  • A.J. is the vice president for Keane Products, a marketing consulting firm. On a business trip to New York City in 2019, he meet
    7·1 answer
  • Mrs. Simpson buys loaves of bread and quarts of milk each week at prices of $1 and 80 cents, respectively. At present she is buy
    9·1 answer
  • A one-brand-name strategy should be adopted when the name cannot be pronounced in the local language, when the brand name is own
    13·1 answer
  • What is the last step in creating a budget
    7·1 answer
  • On January 1, 2019, Sanders Corporation purchased equipment having a fair value of $68,301.30 by issuing a non-interest-bearing,
    13·1 answer
  • Suppose Eric and Ginny are playing a game in which both must simultaneously choose the action Left or Right. The payoff matrix t
    13·1 answer
  • What are human rights
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!