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
1. What does a financial coach do?
finlep [7]

A financial coach is someone that helps their clients with the basics of money management. They help their clients develop secure, healthy money habits that will last. To become a financial cost, one would need to have worked directly with clients and completely understand their needs, know how to address their concerns, and recommend plans to them in a way that makes them feel comfortable. They must work well with numbers, and have good math skills.

4 0
3 years ago
Briefly describe an experiment that would test the premack differential probability principle
amm1812
An experiment that could test the Premack differential probability rule is as per the following; the kids are given two reaction choices, one for playing pinball machine and another for eating confection and these practices are evaluated to figured out which is more plausible for every kid. A portion of the youngsters who discovered to favor one movement. In the second period of the trial, the testing of the youngsters was directed with one oF the two systems. In the primary strategy, eating was a fortifying reaction while playing pinball was the instrumental reaction implying that the youngsters played pinball keeping in mind the end goal to eat the confection.
6 0
3 years ago
On December 31 of the current year, the unadjusted trial balance of a company using the percent of receivables method to estimat
Ymorist [56]

Answer: $4,811

Explanation:

Assuming 6% of outstanding accounts receivable at the end of the current year are estimated to be uncollectible that would be,

= 6% * 98,700

= $5,922

The Allowance for Doubtful Accounts acts as a buffer for the business when bad debts are incurred.

Bad debts are taken from the Allowance as the Allowance has already been removed from the Receivables.

In cases where Bad debts exceed the buffer in the Allowance for Doubtful Debt Account we take everything in it and the remaining bad debt amount is debited to Bad Debt expense.

That would be,

= 5,922 - 1,111

= $4,811

$4,811 is the amount that should be debited to Bad Debts Expense.

3 0
3 years ago
Bill Blackburn is the new mayor of Oceanside, Washington. He discovered that the city-run utility requires a deposit of $50 from
Serjik [45]

Answer:

<em>Theory of justice </em>

Explanation:

A Justice Theory is a 1971 work of John Rawls ' political philosophy and ethics, whereby the writer addresses the problem of distributive justice.

The principle uses a revised sort of Kantian philosophy and a variant form of conventional theory of social contracts.

7 0
3 years ago
n the money creation process, the simple money multiplier assumes that banks hold no excess reserves. What is the consequence of
lyudmila [28]

Answer: The simple money multiplier becomes smaller as less money is loaned out

Explanation:

In the money creation process, the simple money multiplier assumes that thee are no excess reserves that are held by the banks and that there are no currency being held by the public.

The consequence of a bank holding excess reserves will be that the simple money multiplier will become smaller when less money is being loaned out. There will be less money in circulation when excess reserves are held by the banks. This will result in the money multiplier to be smaller.

3 0
2 years ago
Other questions:
  • BarkBark Inc. and Happy Toys Ltd. are considering a merger and are worried that their two organizational cultures will clash. Th
    11·1 answer
  • Ursa Major Solar (UMS) is configuring the lead conversion process. Which two factors should UMS consider before setting up the p
    8·1 answer
  • In 1992, the Enron Development Corporation, a subsidiary of the Houston-based energy company, signed a contract to build the lar
    7·1 answer
  • Consider a corporate bond with a $1000 face value, 8% coupon with semiannual coupon payments, 7 years until maturity, and a YTM
    14·1 answer
  • Rover Corporation purchased a truck at the beginning of 2017 for $109,200. The truck is estimated to have a salvage value of $4,
    9·1 answer
  • The group within an organization that is responsible for monitoring and evaluating the internal control system is called the
    6·1 answer
  • THERE ARE TEN BUTTONS ON THE TABLE
    11·2 answers
  • Market performance in the United States is tracked using stock changes. which use formulas to calculate price​
    10·2 answers
  • What do u want to be when u grow up
    9·2 answers
  • Juno Co. purchased a machine for $10,000 and estimates it will use the machine for three years with a $2,000 salvage value. It e
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!