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
Which of the following is NOT an example that falls within the four major categories of business environment factors for today's
oksano4ka [1.4K]

Answer:

c. fewer government regulations

Explanation:

  • All except the fewer government regulations on the trade of the companies that affect the today's business environment and the word organization. The globalization and the increased play a major role in the collection of the internal and the external factors the customer needs and the expectations that affect the firm's price availability.
5 0
2 years ago
Instructions: Round your answers to 2 decimal places. If you are entering a negative number include a minus sign. a. Using the m
BabaBlast [244]

Answer:

The answer is below

Explanation:

The graph is attached below.

a) The price elasticity of demand is given by:

price elasticity of demand = \frac{\%\ change\ in\ quantity }{\%\ change\ in\ price}=\frac{\Delta Q}{\Delta P}

\Delta Q=\frac{Q_2-Q_1}{(Q_2+Q_1)/2} \\\\\Delta P=\frac{P_2-P_1}{(P_2+P_1)/2}

Price of elasticity demand =   \frac{\frac{Q_2-Q_1}{(Q_2+Q_1)/2} }{\frac{P_2-P_1}{(P_2+P_1)/2} }

Price of elasticity demand =   \frac{\frac{50-100}{(50+100)/2} }{\frac{4.5-4}{(4.5+4.0)/2} }=\frac{-0.6667}{0.1176} =5.7

Since the price of elasticity demand > 1, it is elastic

b) Price of elasticity demand =   \frac{\frac{200-300}{(200+300)/2} }{\frac{3-2}{(3+2)/2} }=\frac{-0.4}{0.4} =1

Since the price of elasticity demand = 1, it is unitary

c) Price of elasticity demand =   \frac{\frac{400-450}{(400+450)/2} }{\frac{1-0.5}{(1+0.5)/2} }=\frac{-0.1176}{0.6667} =0.18

Since the price of elasticity demand < 1, it is inelastic

6 0
2 years ago
Presented below is information related to Hale Corporation: Share Capital—Ordinary, P1 par P4,300,000 Share premium—Ordinary 550
Nadusha1986 [10]

Answer:

$4,850,000

Explanation:

The computation of the total contributed capital related to the ordinary shares is shown below:

= Ordinary share capital + share premium of ordinary share

= $4,300,000 + $550,000

= $4,850,000

We simply added the ordinary share capital and the share premium of ordinary shares so that the total contributed capital could arrive

5 0
2 years ago
You have been approached by the editor of Gentlemen’s Magazine to carry out a research study. The magazine has been unsuccessful
horsena [70]

Answer:

The management research question capable of developing a scientific proposal will be questions that will address the concerns of the management.

1. How Gentlemen’s Magazine can be marketed to shoe manufacturers

2. What is the profitability of shoe manufacturing?

3. What are the main sources of sales for shoe manufacturer?

4. What percentage of clothing stores also deal in the sales of shoes?\

5. What is the percentage demand of male shoes?

6. What is the profitability of shoe sales in general?

7. Will men shoes be a profitable venture for Gentlemen’s magazine? and how profitable?

8. What is the frequency of purchase of men's shoes in a year?

9. How many pairs of shoes do men purchase at one time?

10. What types of men shoes are most likely to be purchase by men?

11. What is the preferred colors of shoes purchased by men?

Explanation:

The management research question capable of developing a scientific proposal will be questions that will address the concerns of the management.

1. How Gentlemen’s Magazine can be marketed to shoe manufacturers

2. What is the profitability of shoe manufacturing?

3. What are the main sources of sales for shoe manufacturer?

4. What percentage of clothing stores also deal in the sales of shoes?\

5. What is the percentage demand of male shoes?

6. What is the profitability of shoe sales in general?

7. Will men shoes be a profitable venture for Gentlemen’s magazine? and how profitable?

8. What is the frequency of purchase of men's shoes in a year?

9. How many pairs of shoes do men purchase at one time?

10. What types of men shoes are most likely to be purchase by men?

11. What is the preferred colors of shoes purchased by men?

8 0
1 year ago
A large open economy has desired national saving of Sd = 1200 + 1000rw, and desired national investment of Id = 1000 - 500rw. Th
exis [7]

Answer: 10%

Explanation:

The Equilibrium real interest rate would be the interest rate that equates the Desired savings to the desired investment for both the National and foreign economy.

Desired national saving + Foreign desired national saving = Desired national investment + Foreign desired national investment

1,200 + 1,000rw + 1,300 + 1,000rw = (1,000 - 500rw) + (1,800 - 500rw)

2,500 + 2,000rw = 2,800 - 1,000rw

2,000rw + 1,000rw = 2,800 - 2,500

3,000rw = 300

rw = 0.1

rw = 10%

7 0
2 years ago
Other questions:
  • A change from an inefficient mix to an efficient mix of output would best be represented with a production possibilities frontie
    15·1 answer
  • Ellie wants to use office 2016 for her catering business. for example, she plans to use word to maintain her collection of recip
    7·2 answers
  • Which of these technologies helps to improve employee efficiency? A. Augmented reality B. Personal information management C. Rea
    6·2 answers
  • According to the ________ cheating model, assuming little or no product differentiation among a small number of firms, if one fi
    15·1 answer
  • The Southside Sweetery has a loyal following. When it recently moved from its longtime storefront to a famous resort area, it to
    15·1 answer
  • Suppose Nicholas owns a business making Christmas tree ornaments. Currently, he makes 300 ornaments a month. At this level of pr
    15·1 answer
  • Patty, a single taxpayer, has $100,000 of U.S. source taxable income and $300,000 of foreign source taxable income from countrie
    12·1 answer
  • Kim will only buy cars from Japanese automakers because she thinks cars made in the United States are of inferior quality. She h
    13·1 answer
  • The combo box (form control) option in macros can be used to substitute for ___ when doing scenario analysis.
    5·1 answer
  • The following transactions apply to Pecan Co. for 2018, its first year of operations:1. Received $100,000 cash in exchange for i
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!