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
In the context of foreign market entry, ________ requires no equity investment and thus has a low risk, low rate of return, and
Oksanka [162]

it is B because franchising is the best option

7 0
3 years ago
Read 2 more answers
Vessels Corporation's net income for the most recent year was $2,532,000. A total of 200,000 shares of common stock and 200,000
Usimov [2.4K]

Answer:

  • The earnings per share of common stock is closest to

D. $11.41.

Explanation:

To find the Price-Earning Ratio first, it's necessary to deduct from the Net Income the part corresponding to Preferred Stock,

which is , $2,532,000 - (200,000*1,25= $250,000) = $2,282,000

Then we calculate the Earning/Share Ratio : $2,282,000/200,000 = 11,41

Shares of Common stock outstanding    200.000     

Shares of Preferred stock outstanding    200.000*$1,25 = $250.000  

NET INCOME Available    $2,282,000  = $ 2,532,000  - $250,000

6 0
3 years ago
When the cost method is used to account for an investment, the carrying value of the investment is affected by a.the earnings an
Dmitrij [34]
Dividends of the invested
6 0
3 years ago
On June 30, 2018, Princeton Company paid $310,000 cash for all assets and liabilities of Streeter, which will cease to exist as
Vesnalui [34]
I don’t know what are you asking, is this multiple choice. Please explain more
4 0
4 years ago
Even the best marketing communication can be wasted if the sender does not first
deff fn [24]

Answer: D) gain the attention of the consumer.

Explanation:

The first and foremost thing is marketing is to gain the attention of the consumer. This is why Adverts usually start with something eye catching and then move on to explain the product.

All other steps in the marketing process including development of brand awareness cannot be implemented if the consumer's attention is not gained.

The first and foremost goal of marketing in simple terms therefore is to first grab their curiosity then gain their attention.

6 0
3 years ago
Other questions:
  • What are the five main columns of a journal?
    9·1 answer
  • Division X makes a part with the following characteristics:
    15·1 answer
  • Please help will give brainliest
    9·2 answers
  • A company's fixed operating costs are $370,000, its variable costs are $3.25 per unit, and the product's sales price is $5.65. W
    13·1 answer
  • The Skulls, a student social organization, has two different locations under consideration for constructing a new chapter house.
    8·1 answer
  • The inflation rate is measured by calculating the percentage change in the consumer price index. True or False
    15·1 answer
  • Suppose that when the price of a 16 oz. to-go cup of gourmet coffee is $4.25, students purchase 750 cups per day. if the price d
    9·1 answer
  • When workers join unions and elect representatives to negotiate with their employers, this is referred to as
    11·1 answer
  • The manager at the Overton Hotel in Lubbock believes that the success of the Texas Tech Red Raider Basketball team has an impact
    5·1 answer
  • Suppose Yolanda needs a dog sitter so that she can travel to her sister's wedding. Yolanda values dog sitting for the weekend at
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!