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
The value of goods imported into mexico exceeds the value of goods exported by that country. this suggests that mexico has a​ __
Simora [160]

Based on the scenario above, the answer is trade deficit. This is considered to be an economic measure in terms of international trade in which the imports of the country are exceeded than of the country’s exports. This is known to be the trade’s negative balance.

4 0
3 years ago
In 2010 the United States posted a current account deficit of -$471 billion. The bulk of the negative value came from: A. a good
Brut [27]

Answer:

A. a goods trade deficit

Explanation:

The current account represent the trade balance (export less import) plus

the net income (person receiving interest, rent or wages from aboard less person and companies paying foreingers) and

the direct payment. ( remittances from wroker to US)

As the US is one of the most open-economies in the world the mayority of this deficit comes from import of good and services from aboard.

Another factor, is that US company invest around the world thus, the net income should be positive.

And becuase the US economy is strong as opposite of Mexico or other Latin America countries, the average US employee abroard will not send their wages to support his family.

Thus, we should ensure the deficit comes from a negative trade deficit.

6 0
4 years ago
If an agreement does not contain an arbitration clause, the parties may, nevertheless, agree to arbitration by entering into a _
juin [17]
Entering into an Alternative Dispute Resolution (ADR) agreement.

Alternative Dispute Resolution is very much akin to arbitration in which the parties that are agreeing to surrender their rights to access the judicial system in a civil court that enables a party to bring a lawsuit against another party that is in said agreement.
7 0
3 years ago
What happened to anyone who could not keep up with the march?
miskamm [114]
The Nazi soldiers were given order to shoot anyone who could not keep up with the march. Those who escape shooting would probably be trampled upon by the moving multitude. <span />
3 0
3 years ago
Heart &amp; Home Properties is developing a subdivision that includes 600 home lots. The 450 lots in the Canyon section are belo
Sophie [7]

Answer:

Each Canyon lot will cost = $10,000, total costs associated to the 450 Canyon lots = $4,500,000

Each Hilltop lot will cost = $20,000, total costs associated to the 150 Hilltop lots = $3,000,000

Explanation:

When you allocate joint costs using the value basis method, the costs will be allocated to the different products using their sales value:

total costs = $4,000,000 + $3,500,000 = $7,500,000

total sales value = (450 lots x $55,000) + (150 lots x $110,000) = $24,750,000 + $16,500,000 = $41,250,000

total costs allocated per $1 of sales value = $7,500,000 / $41,250,000 = $0.181818

Each Canyon lot will cost = $0.18181818 x $55,000 = $10,000, total costs associated to the 450 Canyon lots = $4,500,000

Each Hilltop lot will cost = $0.18181818 x $110,000 = $20,000, total costs associated to the 150 Hilltop lots = $3,000,000

6 0
3 years ago
Other questions:
  • Select the correct answer.<br> What is brainstorming?
    11·2 answers
  • How does the internet help consumers make well-informed decisions?
    13·2 answers
  • The adjusting entry to adjust supplies was omitted at the end of the year. This would affect the income statement by having expe
    13·2 answers
  • Llywelyn, Inc. reports the following information for​ July: Sales Revenue $ 1 comma 000 comma 000 Variable Costs 200 comma 000 O
    7·1 answer
  • As a management consultant, lamont knows that regardless of how good his firm's product might be, the business has little chance
    12·1 answer
  • "The price (P) of designer jeans is affected by the supply (S) and the demand (D).
    14·2 answers
  • You are given the following information: Stockholders' equity as reported on the firm’s balance sheet = $4 billion, price/earnin
    15·1 answer
  • 1. Net income was $60,100. 2. Equipment (cost $21,770 and accumulated depreciation $9,770) was sold for $11,770. 3. Depreciation
    14·1 answer
  • Velocity, a consulting firm, enters into a contract to help Burger Boy, a fast-food restaurant, design a marketing strategy to c
    11·1 answer
  • Which statement best explains the decrease in manufacturing jobs over the next few years?
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!