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
The term used to describe the degree to which tasks in an organization are subdivided into separate jobs is called ________.
lyudmila [28]

Answer:

work specialization

Explanation:

The term being described is known as work specialization. This term, also known as division of labor, is mainly used by companies in order to divide a large job position into smaller, single tasks that can be completed by one individual. The individual that is given such a task is trained thoroughly in order for them to become a specialist in that task and output more precise workloads.

6 0
3 years ago
Fiona, a regional sales manager, works from her office in State U. Her region includes several states, as indicated in the sales
son4ous [18]

Answer:

Payroll factor State U:

  • commissions $50,000
  • fringe benefit package $15,000

Explanation:

State           Sales Generated Fiona’s         Time Spent There

U                        $3,000,000                             20%

V                        $4,000,000                             50%

X                        $8,000,000                             30%

Sales percentage generated in state U = $3,000,000 / $15,000,000 = 20%

so 20% of the $250,000 commissions should be assigned to state U = $50,000

Time spent in state U = 20% x $75,000 fringe benefits = $15,000 assigned to state U

8 0
3 years ago
Using the percentage-of-sales method, the estimated total uncollectible accounts are $7,322. The Allowance for Uncollectible Acc
xenn [34]

Answer:

B. $9,957.

Explanation:

The computation is adjusted amount for Uncollectible account expense is shown below:

= The estimated total uncollectible accounts + debit balance of Allowance for uncollectible accounts

= $7,322 + $2,635

= $9,957

For computing the adjusted amount we added the estimated total uncollectible accounts and the debit balance of Allowance for uncollectible accounts

8 0
3 years ago
In 2017, Orear Manufacturing signed a contract with a supplier to purchase raw materials in 2018 for $700,000. Before the Decemb
MArishka [77]

Answer:

d) as a current liability

Explanation:

Current Liabilities are those liabilities which are payable within one years time e.g trade payable, tax payable etc.

The credit against the purchase of inventory is classified as the trade payable and it is paid in a short time, so it will be reported on the balance sheet in current liability section.

5 0
3 years ago
Oscar owns a building that is destroyed in a hurricane. His adjusted basis in the building before the hurricane is $130,000. His
Alinara [238K]

Answer: $132,000

Explanation:

Oscar's new basis on the building will be the basis of the old building plus any additional investment he added.

This is the because there is no gain on the $140,000 he received because it was an Involuntary Conversion amount and he reinvested it into another building within a period of 2 years.

As there is no gain, the building will retain it's original basis but will add any amount outside the involuntary replacement cost of the building.

The Additional basis will be,

= Cost of building - Insurance

= 142,000 - 140,000

= $2,000

The Basis for the new building is,

= 130,000 + 2,000

= $132,000

3 0
3 years ago
Other questions:
  • Allocation of common costs. Evan and Brett are students at Berkeley College. They share an apartment that is owned by Brett. Bre
    9·1 answer
  • A company's Inventory balance at the end of the year was $188,000 and $200,000 at the beginning of the year. Its Accounts Payabl
    15·1 answer
  • What is the foremost strategic issue that must be addressed by firms when operating in two or more foreign markets? multiple cho
    10·1 answer
  • Clementine Company makes skateboards. They prepare master and flexible budgets and then perform variance analysis after the budg
    13·1 answer
  • To say that a price ceiling is binding is to say that the price ceiling a. results in a shortage. b. is set below the equilibriu
    6·1 answer
  • Supply is the amount needed.<br> O True<br> O False
    10·2 answers
  • Martin wants to provide money in his will for an annual bequest to whichever of his living relatives is oldest. That bequest wil
    11·1 answer
  • A firm that responds to a regulatory rule in a way that permits technical compliance while allowing the firm to violate the spir
    6·1 answer
  • A __________ card is issued by a credit union or bank and allows the user to purchase goods and services by electronically deduc
    14·1 answer
  • With respect to the selection tools that are used in processing applicants for a sales job:Group of answer choicesNone of these
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!