answer.
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]
2 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]2 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
To what extent do stakeholders influence a plan and subsequent implementation of organization restructuring that accommodates ch
nydimaria [60]

Answer: None of the above

Explanation:

None of the options seem to be correct.

Stakeholder is the people who are interested in the the decision made by an organization. When a change takes place in an organization, the stakeholders are affected by such change. Stakeholders include board, managers, shareholders, workers etc.

The first option is wrong as stakeholders are incidental to the change process. They're always ever present in the change process.

The second option is wrong as well. Some stakeholders are decision makers and can influence the potential outcome of organizational restructuring. e.g board etc.

The third option is also incorrect. This is because stakeholder expertise in managing change should be considered by change leaders in the planning of adaptable organizational structures. Some stakeholders are expertise in change management and their knowledge is needed when there is planning of adaptable organizational structures.

That means we're left with only the Fourth option which is the right answer.

8 0
2 years ago
A company is currently selling 10,000 units of product monthly for $40 per unit. The unit contribution margin is $27. The compan
Ludmilka [50]

Answer:

The company should accept the idea because profit will increase by $24,000.

Explanation:

A company is currently selling 10,000 units of product monthly for $40 per unit.

The unit contribution margin is $27.

The company believes that spending $50,000 per month on advertising will allow them to increase the selling price to $45 and that sales will increase by 750 units per month.

The unit contribution margin is the difference between selling price and variable cost per unit.

An increase in the selling price of $5 will cause the contribution margin to increase by $5, from $27 to $32.

Profits is the product of contribution margin and number of output.

At initial price, the profit was

= 10,000\ \times\ \$ 27

= $270,000

At the new price the profit will be

= 10,750\ \times\ \$ 32  - $50,000

= $344,000 - $50,000

= $294,000

The increase in profit

= $294,000 - $270,000

= $24,000

3 0
2 years ago
On June 5, 2017, Javier Sanchez purchased and placed in service a 7-year class asset costing $560,000 for use in his landscaping
bogdanovich [222]

Answer:

A.$538,573 and $6,123

B.Check below

Explanation:

A.

Sanchez's total cost recovery deduction in 2017 is $538,573 and $6,123

B.

Section 179 expense$510,000

Additional first-year depreciation 25,000

[($560,000 – $510,000) × .50]

($50,000×.50)

2017 Cost recovery (MACRS ) 3,573

[($560,000 – $510,000 – $25,000) × .1429

(25,000×.1429)

2017 Total deduction$538,573

($510,000+$25,000+$3,573)

2018 Cost recovery (MACRS ) 6,123

[($560,000 – $510,000 – $25,000) × .2449

(25,000×.2449)

3 0
2 years ago
An insured owns a $50,000 whole life policy. At age 47, the insured decides to cancel his policy and exercise the extended term
Arlecino [84]

Answer:

The face amount of the new term policy would be $50,000

Explanation:

In life insurance, face amount is referred to as the amount paid on the policy's maturity date, on the death of the insured, or if the policy terms permit on his or her total disability.

The face amount of the term policy would remain the same as when it was purchased as provided under the whole life policy. which is $50,000.

8 0
2 years ago
How were the earliest benefits of the Industrial Revolution distributed between factory owners and workers?
qaws [65]
The answer is <span>Factory owners benefited greatly, while conditions for workers were poor.

During the Industrial Revolution, capitalists were focused on getting more profit. They actually have poor management with worker benefits. Workers work long hours and receive insufficient pay for all their work. Their condition moved them to form Unions and held strikes for decent salary and benefits.
</span>
8 0
2 years ago
Read 2 more answers
Other questions:
  • Which of the law ideas might be created under the Elastic Clause?
    12·2 answers
  • Subheads work best for which level of the creative pyramid?
    9·1 answer
  • Kangaroo Company had the following amounts on its balance sheet as of December 31, 2018: Inventory $325,000 Notes Payable 100,00
    6·1 answer
  • Emma supervises and leads a team implementing the upgrade of a company's
    11·1 answer
  • Huron has provided the following year-end balances: Cash, $25,000 Patents, $7,900 Accounts receivable, $9,300 Property, plant, a
    5·1 answer
  • The Digby's workforce complement will grow by 20% (rounded to the nearest person) next year. Ignoring downsizing from automating
    14·1 answer
  • Macy wants to buy a skateboard for $42. She has $95 in her account. She spent $12.99 to buy stationary. She also wants to buy so
    12·1 answer
  • Draw a labor supply curve and a labor demand curve. Label them LS0 and LD0. Draw a point the equilibrium quantity of labor and t
    9·1 answer
  • Tammy can buy an asset this year for $1,000. She is expecting to sell it next year for $1,050. What is the asset’s anticipated p
    10·1 answer
  • Which of the following answer options are your employer's responsibility? (OSHA)
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!