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
The next step after developing a market-product grid and estimating market sizes in the segmentation process is to ________ appr
joja [24]

Answer:

<u>Select</u>

Explanation:

Marketing segmentation is usually done on the basis of demographic, which is based upon age composition or the population, psychographic which is based upon personality traits and the attitudes of consumers, geographical which is based as per the location of the consumers and behavioral which is based upon buyer buying habits and trends of past purchases.

Once the products in a particular market have been assigned i.e product market grid, and market size been estimated in terms of the estimated number of consumers within a segment, the next step is to select appropriate target markets.

Target markets refer to identified consumer groups with similar tastes, preferences and buying habits.

5 0
3 years ago
The Johnson Family is looking to buy a new house on Belmont Road. Their insurance deductible is increased by $500 if they live m
user100 [1]

Answer:

a) Absolute Value Inequality => Absolute(0 + y) < 2

b) -2 < y < 2

Which means, Johnson Family has to live within the range of -2 to +2 from the fire department. Otherwise, they will have to pay 500 USD as increased deductible.

Explanation:

<u><em>Johnson Family has to live within the range of -2 to +2 from the fire department. </em></u>

<em>a) Absolute Value Equation:</em>

Absolute(0 + y) < 2

where y represent the location of the new house and 0 represents the location of the fire department.

Furthermore,

<em>Absolute(0 + y) < 2 = (0 + x) < 2 when (0 + y) is +ve. </em>

and

<em>Absolute(0+y) <2 =  -(0 + x) < 2 when (0 + y) is -ve. </em>

b) When (0 + y) is +ve,

we have,  (0 + y) < 2.

<em>Solving for y and subtracting 0 from both sides. </em>

0-0 + y < 2 - 0

<em>y < 2</em>

and when (0 + y) is -ve,

<em>we have, - (0 + y) < 2. </em>

Solving for y:

- 0 - y < 2

multiplying negative from both sides

<em>y > - 2</em>

<em>So, we have -2 < y < 2 </em>

<em>Johnson Family has to live within the range of -2 to +2 from the fire department. Otherwise, they will have to pay 500 USD as increased deductible. </em>

7 0
3 years ago
Credit score is used to determine your financial worth ?
Sergeu [11.5K]
The higher the score, the better a borrower looks to potential lenders. A credit score is based on credit history: number of open accounts, total levels of debt, and repayment history, and other factors. Lenders use credit scores to evaluate the probability that an individual will repay loans in a timely manner.
4 0
2 years ago
Read 2 more answers
EstWhich titles. Fits this vin diagram best
jarptica [38.1K]

Answer:

Title 1 is "careers" and title 2 is "jobs"

Explanation:

4 0
3 years ago
A portfolio that combines the risk-free asset and the market portfolio has an expected return of 6.5 percent and a standard devi
mario62 [17]

Answer: Step 1) Find share of market in the Portfolio

(11.5-3.5)x+3.5=6.5

8x=3

x=3/8

x=0.375

=37.5%

SD of market portfolio= 0.375x+0=9.5

x=9.5/0.375

=25.33%

correl = cov / (std 1 * std2)

0.4=COV/0.2533*0.545

COV= 0.2533*0.545*0.4=0.05

cov of 2 assets = b1 * b2 * variance of market

0.05=B1*1*0.2533^2

B of security=0.0032

Capm Model

3.5+0.0032(11.5-3.5)=3.5256% expected return

Explanation:

Step 1) Find the share of market in the portfolio in order to find market SD

Step 2)  Find Covariance betweens security and market by using both SDS and correlation

Step 3) Find Beta of Security using Co variance

Step 4) Use the Beta in CAPM model in order to find expected return

4 0
3 years ago
Other questions:
  • Expected volume of production ​50,000 units Actual volume of production ​47,500 units Budgeted fixed overhead​ costs(for 50,000
    9·1 answer
  • The demand curve faced by a nondiscriminating pure monopoly is _____.
    11·1 answer
  • A warrantless search of a vehicle must be based on:
    6·1 answer
  • The weekly gathering of friends and family in an Iranian-American home, where rituals, food, and cultural practices from Iran ar
    13·1 answer
  • A popular sports company grants a license to people who use their logo on T-shirts and caps. They charge the company for the rig
    5·2 answers
  • The Flores Family loves to go sailing on the weekends. Mr. Flores has decided to purchase a more spacious sailboat. The sailboat
    11·1 answer
  • A computer manufacturer has a basic model, a business model and a premium model, each with a variety of options. They each have
    14·1 answer
  • ZOOm you there lets get on.
    12·2 answers
  • A company issues a 10-year, callable bond at par with 8% annual coupon payments. The bond can be called at par in one year after
    14·1 answer
  • Customer groups represent different segments if: ___________.a. Their needs require different products/services or different pri
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!