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
Which of the following are also known as state sales taxes?
Olenka [21]
(A)Consumption Tax is the answer.........
7 0
3 years ago
Sue's teachers say she isn't motivated by anything. she shows little interest in toys, activities or food. an exception appears
Damm [24]
<span>What Sue's teachers can do to broaden her reinforcement repertoire is to incorporate toys, various activities or food and that cd to play in the background. While Sue's at it, playing because her favorite cd is there, the teacher can slowly lower the volume of the cd so that Sue can focus on playing toys and other stuff.</span>
7 0
3 years ago
Congress passed a law imposing penalties for displaying "indecent" material online where children could see it. If the U.S. Supr
vichka [17]

Answer:

TRUE

Explanation:

6 0
4 years ago
Kingbird Construction Company changed from the completed-contract to the percentage-of-completion method of accounting for long-
sergey [27]

Answer:

a) 2021 year income: 526,540

b) journal entries

income tax expense    225.660‬ debit

    income tax deferred liability (*1)  49.650‬ debit

    income tax payable    176.010‬ credit

Explanation:

Year   Accounting Tax purpose Difference

2020 752200 586700 165500

2021 683500 444700 238800

2021

752,200 x 30% = 225,660

after tax income: 526.540‬

2022

683,500 x 30% = 205,050

after tax income:   478.450‬

We recognize the income tax expense n the accounting method of revenue/expense recognizition

while, the payable will use the goverment purposes.

Then, the differnce wi considered either income tax deferred.

*1 it is a liability as the company is paying lower taxes to day to pay more than before.

3 0
3 years ago
Identify and analyze a department in your organization that experiences frequent equipment or process failures. If you are not c
lord [1]

Answer:

Find the explanation below.

Explanation:

The name of my organization is Prime Plc. known for the production of confectionaries. The Production Department in my organization has been experiencing frequent equipment failures quite recently. A close investigation showed that the delays were caused by a breakdown of the sugar mills, mixers and, coating machines. This has resulted in delays in the production process. To improve these failures, I believe that the organization should:

1. Employ Technicians who can quickly carry out repair work on these machines when they breakdown instead of outsourcing the repair work for this would take a longer amount of time to get the machines up and running.

2. Introduce the periodic maintenance of these machines. Machines are subject to wear and tear, so I would suggest that the maintenance of these machines is carried out within intervals of three months.

3. Train the production personnel on the proper usage of these machines. Production personnel should be updated on current and effective ways of handling machines so as to guarantee their safety and longer use.

4. Make provisions for backup machinery and equipment. The organization would do well to purchase backup equipment especially for machines that the organization cannot do without so that in the event of an equipment failure, the production process would not be stalled.

When these measures are considered, there would be a significant improvement in the production department.

8 0
3 years ago
Other questions:
  • Jan vermeer's woman holding a balance is a perfect example of ____________.
    13·1 answer
  • Ski Safety sells emergency safety and rescue products to ski patrols and rescue workers at prices that are below those of its co
    15·2 answers
  • On January 1, 2012, Mehan, Incorporated purchased 15,000 shares of Cook Company for $150,000 giving Mehan a 15% ownership of Coo
    9·1 answer
  • 5 An insured has four separate but identical policies written by different insurers to cover her $100,000 building. Each policy
    13·1 answer
  • McKinnon Enterprises owns a professional ice hockey team, the Rockford Penguins. The company sells season tickets for its upcomi
    5·1 answer
  • Clemmens Company applies overhead based on direct labor cost. Estimated overhead and direct labor costs for the year were $120,5
    12·1 answer
  • Two mutually exclusive projects have 3-year lives and a required rate of return of 10.5 percent. Project A costs $75,000 and has
    5·1 answer
  • Net primary productivity is ________.
    14·2 answers
  • Tenpenny Tower was built in 1985. However, the building has been constantly maintained and remodeled. In valuation terms, the bu
    9·1 answer
  • When a customer does not understand his or her role in the service delivery process, he or she is contributing to provider:_____
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!