Ask question

Ask question

All categories

2 years ago

10

Write a SELECT statement that returns the same result set as this SELECT statement. Substitute a subquery in a WHERE clause for

the inner join. SELECT DISTINCT VendorName FROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorID ORDER BY VendorName

1 answer:

sergiy2304 [10]2 years ago

6 0

Answer:

SELECT distinct VendorName FROM Vendors

WHERE VendorID IN (

SELECT VendorID FROM Invoices

)

Explanation:

You might be interested in

A 60-kg woman holds a 9-kg package as she stands within an elevator which briefly accelerates upward at a rate of g/4. Determine

Anuta_ua [19.1K]

Answer:

force R = 846.11 N

lifting force L = 110.36 N

if cable fail complete both R and L will be zero

Explanation:

given data

mass woman mw = 60 kg

mass package mp = 9 kg

accelerates rate a = g/4

to find out

force R and lifting force L and if cable fail than what values would R and L acquire

solution

we calculate here first reaction R force

we know elevator which accelerates upward

so now by direction of motion , balance the force that is express as

R - ( mw + mp ) × g = ( mw + mp ) × a

here put all these value and a = g/4 and use g = 9.81 m/s²

R - ( 60 + 9 ) × 9.81 = ( 60 + 9 ) × g/4

R = ( 69 ) × 9.81/4 + ( 69 ) 9.81

R = 69 ( 9.81 + 2.4525 )

force R = 846.11 N

and

lifting force is express as here

lifting force = mp ( g + a)

put here value

lifting force = 9 ( 9.81 + 9.81/4)

lifting force L = 110.36 N

and

we know if cable completely fail than body move free fall and experience no force

so both R and L will be zero

5 0

2 years ago

You should be extra careful during the hours of sunrise, sunset, and nighttime because _____. A. of increased law enforcement ac

torisob [31]

Answer:

B, its the only valid answer

5 0

2 years ago

Determine the deflection at the center of the beam. Express your answer in terms of some or all of the variables LLL, EEE, III,

Rom4ik [11]

Answer:

See explanations for step by step procedures to get answer.

Explanation:

Given that;

Determine the deflection at the center of the beam. Express your answer in terms of some or all of the variables LLL, EEE, III, and M0M0M_0. Enter positive value if the deflection is upward and negative value if the deflection is downward.

4 0

2 years ago

A four-variable logic function that is equal to 1 if any three or all four of its variables are equal to 1 is called a majority

gulaghasi [49]

Answer:

1. Assumption

2.Truth Table

3.K-Map

4.Mapping and Final Expression

5 0

2 years ago

A pressure gage connected to a tank reads 50 psi at a location where the barometric reading is 29.1 inches Hg. Determine the abs

Effectus [21]

Answer:

Absolute pressure , P(abs)= 433.31 KPa

Explanation:

Given that

Gauge pressure P(gauge)= 50 psi

We know that barometer reads atmospheric pressure

Atmospheric pressure P(atm) = 29.1 inches of Hg

We know that

1 psi = 6.89 KPa

So 50 psi = 6.89 x 50 KPa

P(gauge)= 50 psi =344.72 KPa

We know that

1 inch = 0.0254 m

29.1 inches = 0.739 m

Atmospheric pressure P(atm) = 0.739 m of Hg

We know that density of Hg = $13.6\times 10^3\ kg/m^3$

P = ρ g h

P(atm) = 13.6 x 1000 x 9.81 x 0.739 Pa

P(atm) = 13.6 x 9.81 x 0.739 KPa

P(atm) =98.54 KPa

Now

Absolute pressure = Gauge pressure + Atmospheric pressure

P(abs)=P(gauge) + P(atm)

P(abs)= 344.72 KPa + 98.54 KPa

P(abs)= 433.31 KPa

3 0

2 years ago