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
Why was agricultural sector declared as critical industry and exempt from the hardest lockdown regulations
Neko [114]

Answer:

Kindly check explanation

Explanation:

Food production and consumption is critical and key to survival, no matter an established and generally accepted number of daily square meal of 3 is widely adopted. This gives a clue tgta, no matter a country's problem or issues they face, aspects which concerns food and generally agriculture would be treated preferentially. Following the outbreak and severe spread of the deadly virus, it became imperative that affected nations introduced critical measures to try and curtail its spread, stringent measures include ; restriction of movement, strict emphasis on social distancing, hence, the need to reduce the number of people on a particular site or work area, travel restrictions, among others. This restrictions had s here effect on the agriculture and the food supply chain and its effect was quickly very noticeable as people would eventually die of hunger if nothing was done. This prompted government to introduce exemptions and preference afforded to the agricultural sector ; such as keppibg trade channels open in other to facilitate food distribution, timely observation and monitoring of food crisis among others.

4 0
3 years ago
In order for private bargaining to result in the efficient outcome,A) an injunction must be requestedB) property rights must be
lianna [129]

Answer:

The correct answer is letter "B": property rights must be clearly assigned to the parties involved in the dispute.

Explanation:

Named after British lawyer and economist Ronald Coase (<em>1910-2013</em>) the Coase Theorem states when there are competitive markets and no transaction costs bargaining will lead to an efficient and mutually beneficial outcome. The theorem affirms that when property rights are defined and divided, parties will gravitate to the most efficient and beneficial outcome.

3 0
3 years ago
Choose all that apply. Select each of the costs or consequences of being financially irresponsible. having a low credit score ea
Aleksandr [31]
I feel all can apply?
hope this helped?! :/
8 0
3 years ago
Read 2 more answers
Jillian wants to plan her finances because she wants to create and maintain her tax and credit history. She also wants to chart
gladu [14]

The correct answer is; October 1st and September 30th.

Further Explanation:

There are approximately 3 types of fiscal years. They are;

  1. Business
  2. Federal
  3. Non-profit

The federal fiscal year always starts on October 1st and will end on September 30th the following year. These are divided into four quarters each year. This will cover a 12 month calendar year.

A fiscal year can contain 365 or 366 days depending if there is a leap year. This is used as a starting place to start commencing your record keeping in order and when to conclude for the year.

When keeping financial records numerous things needs to be kept for the following year. Some of the things that needs to be kept are; precise records, receipts, contracts, check stubs, and the budget used.

Learn more about the fiscal year at brainly.com/question/13648773

#LearnwithBrainly

7 0
3 years ago
Manuel works for a very large company that sells stocks to shareholders. This is an advantage for which type of business structu
Rom4ik [11]

Answer:

Corporation

Explanation:

A corporation is a business ownership structure where the business is considered a legal entity separate from the owners. A corporation is subdivided into small units known as shares. Owning a share implies owning part of the corporation. Shareholders own the shares and the corporation.

The shares of a public corporation can be acquired by purchasing them at the security exchange market.  Anyone can purchase shares and become a shareholder.

3 0
3 years ago
Other questions:
  • The personal connections that consumers make with a brand and its key attributes is referred to as _______.
    12·1 answer
  • How can you use spreadsheets both at home and at the office? describe the office business functions which can use electronic spr
    5·1 answer
  • What is the primary benefit for people and nations that engage in trade?
    5·1 answer
  • When resources are scarce, power differences across subunits are _________; when resources are plentiful, subunit power differen
    8·1 answer
  • In the manufacture of 8,000 units of a product, direct materials cost incurred was $154,600, direct labor cost incurred was $84,
    12·2 answers
  • Kevin and Bob have owned and operated SOA as a C corporation for a number of years. When they formed the entity, Kevin and Bob e
    13·1 answer
  • The records of Lohse Stores included the following data: Inventory, May 1, at retail, $14,500; at cost, $10,440 Purchases during
    13·1 answer
  • In your opinion, do we need to use a structured decision making model to make decisions in business.
    10·1 answer
  • Income statement data for Whirlpool Industries from the company’s 2016 financial statements follow. Use these data to reformulat
    9·1 answer
  • The following information is taken from the accounts of Latta Company. The entries in the T-accounts are summaries of the transa
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!