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
Suppose that the government decides to charge cola consumers an excise tax. Before the tax, the market is in equilibrium, where
Hitman42 [59]

Answer:

The answer is: The excise tax on cola beverages is $2 per case.

Explanation:

Excise taxes are taxes levied on certain goods or services.

In this case the price of cola beverages is $4 per case, since excise taxes are included in the price of the product, then the excise tax on cola beverages = price paid by consumers - price received by producers = $4 - $2 = $2

8 0
3 years ago
Asset A and B have expected returns of 5% and 3% per year respectively. Their annual volatilities are both 20% and the correlati
Novay_Z [31]

Answer:

1. Weight of A=0.5, Weight of B= 0.5

2. Asset A has the highest shape ratio. The weight of A and B in the optimal risky portfolio that has the highest shape ratio is:

Weight of A= 0.105, Weight of B= 0.895

Explanation:

Expected return of Asset A= 5%Expected return of Asset A= 5%

Expected return of Asset B= 3%

Annual volatilities of Asset A= 20%

Annual votalities of Asset B= 20%

1. Correlation coefficient = 30% = 0.3 < 1

Risk Free Rate = 1% =0.01

1. Weight of A and B in portfolio with minimal risk is:

Weight of A= β^2B - Cov (XAXB) /β^2A + β^2B - 2Cov (XAXB)

Therefore,

CovXAXB = PAB (Volatility of A) (Volatility of B)

= 0.3 × 0.2 × 0.2

= 0.012

Hence,

Weight of A= (0.2)^2 - 0.012 / (0.2)^2 + (0.2)^2 - 2(0.012)

Weight of A= 0.04 - 0.012 / 0.04 + 0.04 - 0.024

= 0.028/ 0.08 - 0.024

= 0.028/ 0.056

=0.5

Weight of A = 0.5

Weight of B= 1 - Weight of A

Weight of B= 1 - 0.5

Weight of B= 0.5

2. Shape ratio of A= RA - Rf / β

= 0.05 - 0.01 / 2

= 0.04/2

= 0.02 =20%

Shape ratio of B= RB - Rf / β

= 0.03 - 0.01/ 2

0.02 / 2

=0.01 = 10%

So, Asset A has the highest shape ratio

Cov (XAXB) = PAB (Volatility of A) (Volatility of B)

= 0.03 × 0.2 × 0.1

= 0.006

Weight of A= β^2B - Cov (XAXB) /β^2A + β^2B - 2Cov (XAXB)

Weight of A = (0.1)^2 - 0.006 / (0.2)^2 + (0.1)^2 - 2(0.006)

= 0.01 - 0.006 / 0.04 +0.01 - 0.012

= 0.004/ 0.05 - 0.012

= 0.004/ 0.038

= 0.105

Weight of A = 0.105

Weight of B= 1 - 0.105

Weight of B= 0.895

3 0
3 years ago
Rowell Company spent $3 million two years ago to build a plant for a new product. It then decided not to go forward with the pro
ELEN [110]

Answer:

B. If the building could be sold, then the after-tax proceeds that would be generated by any such sale should be charged as a cost to any new project that would use it.

Explanation:

The proceeds from a potential sale are the opportunity cost of using the building for a given project instead of selling to a third party. Not including any cost will lead to project not recovering the entire capital used in it.

Is important to notice this is the after-tax proceeds from the sale of the building.

3 0
3 years ago
The Clemson Company reported the following results last year for the manufacture and sale of one of its products known as a Tam.
Nikitich [7]

Answer:

See below

Explanation:

With regards to the above information, there would be no sales if Tam were to be dropped. Also, there would be no cost associated with it other than $145,000 fixed manufacturing overhead.

Again, since the net loss operating loss was $55,000, the $145,000 would increase that loss by $90,000.

7 0
3 years ago
Anyone have an idea how to create a NPV Spreadsheet which intakes a 6% discount factor.
Whitepunk [10]

The way to calculate an NPV Spreadsheet using the NPV Function are:

  • =NPV(discount rate, series of cash flow)
  • Step 1: Set a discount rate in a cell.
  • Step 2: Establish a series of cash flows (must be in consecutive cells).
  • Step 3: Type “=NPV(“ and select the discount rate “,” then select the cash flow cells and “)”.

<h3>What is an NPV Function?</h3>

This refers to the excel function that is used to calculate the net present value and the discount rates for cash flows.

Hence, we can see that given that you have the discount factor, the annual operating costs, and annual benefits, you would then need to add the present value of all +ve cash flows and subtract the present value of all -ve cash flows.

Read more about discount factors here:

brainly.com/question/8965865

#SPJ1

5 0
2 years ago
Other questions:
  • Which of the following is a clear benefit of international marketing? expands the customer base for products and services allows
    14·1 answer
  • Which of the following statements is correct? a. A security's beta measures its diversifiable (firm-specific) risk relative to t
    14·1 answer
  • A manager employed 100 workers at the beginning of an accounting period, and 120 workers at the end of the period. During the ac
    8·1 answer
  • The following information pertains to Eagle Co.'s Year 5 sales: Cash Sales Gross $ 80,000 Returns and allowances 4,000 Credit sa
    7·1 answer
  • Travis International has a one-time expense of $1.13 million that must be paid two years from today. The firm can earn 4.3 perce
    5·1 answer
  • Indigo Travel, Inc. sells tickets for a dude ranch excursion at Weeping T Ranch to Big City Corporation employees. The total pac
    7·1 answer
  • B was 42 when the life insurance policy was issued. 42 is referred to as the ______ age of the policy. A
    5·1 answer
  • Tammie was communicating to her employees the proper way to handle abuse in the workplace. one individual kept interjecting comm
    8·1 answer
  • Amounts withheld from each employee for social security and medicare vary by state.
    6·1 answer
  • Rosalie is a sales consultant for Avon Cosmetics. This illustrates
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!