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
In computing depreciation, salvage value isa. the fair market value of a plant asset on the date of acquisition.b. subtracted fr
kirill115 [55]

Answer:

c. an estimate of a plant asset's value at the end of its useful life

Explanation:

The salvage value or the residual value is the estimated value of the fixed asset which can be received at the end of its useful life. So, neither it is a fair market value of a plant asset , nor it is deducted from the accumulated depreciation.

The treatment of the residual value under the straight-line method or any other method is shown below:

The depreciation expense under the straight-line method is shown below:

= (Original cost - residual value) ÷ estimated life in years

The residual value should always be deducted from the original cost of fixed asset

5 0
2 years ago
In classifying the kinds of projects an organization has in its portfolio, projects that are typically needed to support current
erastova [34]
Compliance (must do) projects.
6 0
2 years ago
_______________ involves you imagining yourself achieving your final goal.
otez555 [7]
I’d say Outcome visualization since it involves seeing yourself achieving your goal.
3 0
2 years ago
Read 2 more answers
________ is a promotional tool in which a person communicates one-on-one with potential customers.
katen-ka-za [31]
I chose direct marketing
3 0
2 years ago
If a company has a capital structure of $5,000,000 common stock with a cost of 17%, $2,000,000 bonds at 4%, $1,000,000 of short
rjkz [21]

Answer:

Explanation:

Weighted Average Cost of Capital; formula is as follows;

WACC = wE*re + wP*wp + wD*rd(1-tax)

where w= weight of...

r = cost of ...

E= common equity

P = preferred stock

D = Debt

Find the weights of each source of capital;

WACC = (0.50*0.17) +(0.20*0.03) + [0.20*0.04(1-0.40)] +[0.10*0.07(1-0.40)]

WACC = 0.085 +0.006 + 0.0048 + 0.0042

WACC = 0.1 or 10%

3 0
2 years ago
Other questions:
  • g One of the advantages to using common-sized income statements for analysis is _____________________ Group of answer choices a.
    6·1 answer
  • About what percentage of land in the United States is privately owned by citizens, corporations and nonprofit organizations?
    11·1 answer
  • If both the production of goods and services increase and prices rise, then the change in nominal GDP
    8·1 answer
  • On January 1 of the current reporting year, Coda Company's projected benefit obligation was $29.4 million. During the year, pens
    14·1 answer
  • Dinklage Corp. has 7 million shares of common stock outstanding. The current share price is $79, and the book value per share is
    6·1 answer
  • Ireland Corporation obtained a $40,000 note receivable from a customer on June 30, 2016. The note, along with interest at 6%, is
    12·1 answer
  • A company has decided that it no longer needs to extensively count and inspect the products it buys from a particular supplier.
    9·1 answer
  • The local supermarket buys lettuce each day to ensure really fresh produce. Each morning, any lettuce that is left from the prev
    14·1 answer
  • How can setting goals help me get some of the things I need or want?
    13·2 answers
  • A variable costing income statement ______. Multiple select question. calculates contribution margin, while the absorption costi
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!