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
Could someone help me please?!
never [62]
Help whit what business do you have 
6 0
3 years ago
Esquire Comic Book Company had income before tax of $1,550,000 in 2021 before considering the following material items: 1. Esqui
olga2289 [7]

Answer:

                   Esquire Comic Book Company

                                Income Statement

                For the Year Ended December 31, 2021

Operating income                                                 $1,550,000

Restructuring costs                                                 ($60,000)

Income from continuing operations b/ Taxes     $1,490,000

<u>Income tax expense                                              ($372,500)</u>

Income from continuing operations                                        $1,117,500

Discontinued operations:

  • Operating income                                          $610,000
  • Loss on disposal                                          ($395,000)
  • <u>Income tax on discontinued operations       ($53,750)</u>

Income from discontinued operations                                     $161,250

<u>Net income                                                                             $1,278,750</u>

Explanation:

Income from discontinued operations must be reported separately, but any restructuring costs must be included as operational expenses.

3 0
3 years ago
Devon invested $10,500 in three different mutual funds. A fund containing large cap stocks made a 6.7% return in 1 yr. A real es
madreJ [45]

Answer:

Amount invested in a fund containing large cap stocks = $6,000

Amount invested in a real estate fund = $1,500

Amount invested in a bond fund = $3,000

Explanation:

Let:

x = Amount invested in a fund containing large cap stocks = 4 * y = 4y

y = Amount invested in a real estate fund

z = Amount invested in a bond fund =

For total amount invested, we have:

T = total amount invested = x + y + z = $10,500

Therefore, we have:

4y + y + z = $10,500

5y + z = $10,500 ……………………….. (1)

From equation (1), we have:

z = 10,500 - 5y …………………….(2)

Also, for the net returns, we have:

6.7%x - 15.6%y + 4.9%z = $315

0.067(4y) - 0.156y + 0.049z = 315

0.268y - 0.156y + 0.049z = 315

0.112y + 0.049z = 315 ………………… (3)

Substitute equation (2) for z in equation (3), we have:

0.112y + 0.049(10,500 - 5y) = 315

0.112y + 514.50 - 0.245y = 315

0.112y - 0.245y = 315 - 514.50

-0.133y = -199.50

y = -199.5 / -0.133

y = 1,500

x = 4y = 4 * 1,500 = 6,000

From equation (2), we have:

z = 10,500 - 5y = 10,500 - (5 * 1,500) = 3,000

Therefore, we have:

Amount invested in a fund containing large cap stocks = $6,000

Amount invested in a real estate fund = $1,500

Amount invested in a bond fund = $3,000

Checking this, we have:

Total amount invested = $6,000 + $1,500 + $3,000 = $10,500

8 0
3 years ago
The language of price controls
mel-nik [20]

Answer:

1) The government prohibits gas stations from selling gasoline for more than $3.40 per gallon.  

This statement is an example of price ceiling as the gas stations cannot raise their price above $3.40 but can sell it at any price lower than the ceiling price of $3.40. This is binding

2) Due to new regulations, gas stations that would like to pay better wages in order to hire more workers are prohibited from doing so. This is neither a price ceiling or floor as government isn't directly affecting the price with their policy

3) The government has instituted a legal minimum price of $3.40 per gallon for gasoline. This is an example of price floor and is binding. The reason it is a price floor is because the petrol stations cannot charge a price below $3.40 but can charge any price above the floor price of $3.40

Explanation:

4 0
3 years ago
Which of the following is NOT a valid method of modifying cash flows to produce a​ MIRR? A. Turn multiple negative cash flows in
faltersainse [42]

Answer: the correct answer is A. Turn multiple negative cash flows into a single negative cash flow by summing all negative cash flows over the​ project's lifetime.

Explanation: MIRR stands for Modified Internal rate of return. If you add up all negative cash flows in just one  you are not taking into account a very important variable which is "time". It is not the same if you have a negative cash flow in 2 years than in 5 years.

4 0
4 years ago
Other questions:
  • One tip for working with colleagues from different generations is to multiple choice stick to basic technology for teamwork. def
    13·2 answers
  • High Mountain Lumber (HML) has normal budgeted overhead costs of $115,150 and a normal capacity of 35,000 direct labor hours for
    8·1 answer
  • What is brand awareness?
    8·2 answers
  • A deli is offering a special for its sandwiches. a customer will receive three free sandwiches for every five sandwiches purchas
    8·1 answer
  • The balance sheet of Bravo Corporation contains the following list of assets: Cash $8,500,000; Land, $4,700,000; Buildings, $1,3
    12·1 answer
  • The member countries of BERPHO, a regional free trade area wanted to adopt a common currency, the "BERPH." The "BERPH" was model
    6·1 answer
  • Suppose there are three factories in Macroland and the following occurred in 2019: Metal, plastic and a car factory. Metal facto
    15·1 answer
  • Colt Football Co. had a player contract with Watts that is recorded in its books at $5,600,000 on July 1, 2014. Day Football Co.
    11·1 answer
  • Why would a business prefer to keep an invention secret instead of applying for a patent
    8·1 answer
  • How does a system at equilibrium respond to the addition of more product.
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!