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
Simple interest is paid only on the .
jekas [21]

Answer:

Simple interest is paid only on the original amount borrowed.

3 0
3 years ago
Read 2 more answers
Select the correct statement from the following,assuming Carmichael Company had a favorable direct materials price variance of $
Murljashka [212]

Answer:

Total direct material variance= $1,000 favorable

Explanation:

Giving the following information:

Company had a favorable direct materials price variance of $3,000 and an unfavorable direct materials usage variance of $2,000.

<u>To calculate the total direct material variance, we need to use the following formula:</u>

<u></u>

Total direct material variance= price variance +/- quantity variance

Total direct material variance= 3,000 - 2,000

Total direct material variance= $1,000 favorable

4 0
3 years ago
Sorin Inc., a company that produces and sells a single product, has provided its contribution format income statement for Januar
Zigmanuir [339]

Answer:

Total Contribution Margin= $50,388

Explanation:

Giving the following information:

Sales (3,400 units) $ 88,400

Variable expenses 43,316

We need to calculate the selling price and unitary variable cost:

Selling price= 88,400/3,400= $26

Unitary variable cost= 43,316/3,400= $12.74

Now, we can calculate the total contribution margin for 3,800 units.

Sales= 26*3,800= 98,800

Variable cost= 12.74*3,800= (48,412)

Contribution margin= 50,388

3 0
2 years ago
What type of promotion takes place at trade shows?
ira [324]

B. Personal Selling

A trade show is an event where members of a particular industry or group come together and view displays and booths from various companies with their products and services. The company reps are involved in personal selling to the trade show attendees.

4 0
3 years ago
Read 2 more answers
When managers are flexible, creative and willing to learn from mistakes, they are addressing which aspect of emerging public iss
defon

Managers are handling complexity when they are adaptable, imaginative, and prepared to learn from mistakes.

Describe complexity.

According to the scientific theory of complexity, certain systems exhibit behavioral traits that are utterly outside the scope of any traditional examination of the system's component pieces. These phenomena, also known as emergent behavior, appear to be present in a variety of complex living organism-based systems, such as the stock market and the human brain. For instance, according to complexity theorists, a stock market crash is an emergent result of the activities of several individual investors on a complex financial system, just as human awareness is an emergent characteristic of a complex network of neurons in the brain.

to know more about complexity

brainly.com/question/4667958

#SPJ4

6 0
1 year ago
Other questions:
  • A stock index is valued at $800 and pays a continuous dividend at the rate of 3% per year. The 6-month futures contract on that
    14·1 answer
  • The method for providing solutions to union-management conflicts over interpretation or violation of a collective bargaining agr
    5·2 answers
  • Which of the following statements is false?
    5·2 answers
  • The maintenance expense (paid at the end of the year) on a machine, with 6 years of useful life, is expected to be (in constant
    6·1 answer
  • Tanning Company analyzes its receivables to estimate bad debt expense. The accounts receivable balance is $390,000 and credit sa
    6·1 answer
  • An investment will pay $200 at the end the year, $250 at the end of the next year, $400 at the end of the third year, and $500 a
    12·1 answer
  • Net income was $240,000 for the year. Throughout the year the company had outstanding 12,000 shares of 6%, $50 par value preferr
    15·2 answers
  • The family business is looking to expand, and some members of the family, but not all, feel that it might be worth bringing in s
    6·1 answer
  • A special kind of imperfectly competitive market that has only two firms is called.
    11·2 answers
  • The american economy is a(n) ________ economy, of an economy in which economic activities occur between the country and the inte
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!