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

Which of the following power tools has a revolving vertical shaft and a cutter? *

Morgarella [4.7K]

Saber saw I’m pretty sure

4 0

2 years ago

Read 2 more answers

Giving free brainlist first 1

kaheart [24]

Hi! Hope you're having a great day!

8 0

2 years ago

A 3-in-thick slab is 10 in wide and 15 ft long. The thickness of the slab is reduced by 20% and width increases by 3% in a hot-r

xxMikexx [17]

Answer: l = 2142.8575 ft

v = 193.99 ft/min.

Explanation:

Given data:

Thickness of the slab = 3in

Length of the slab = 15ft

Width of the slab = 10in

Speed of the slab = 40ft/min

Solution:

a. After three phase

three phase = (0.2)(0.2)(0.2)(3.0)

= 0.024in.

wf = (1.03)(1.03)(1.03)(10.0)

= 10.927 in.

Using constant volume formula

= (3.0)(10.0)(15 x 15) = (0.024)(10.927)Lf

Lf = (3.0)(10.0)(15 x 15)/(0.024)(10.927)

= 6750 /0.2625

= 25714.28in = 2142.8575 ft

b.

vf = (0.2 x 0.2 x 3.0)(1.03 x 1.03 x 10.0)(40)/(0.024)(10.927)

= (0.12)(424.36)/0.2625

= 50.9232/0.2625

= 193.99 ft/min.

4 0

2 years ago

Technician A says that the neutral safety switch must be bad and should be replaced. Technician B says that the neutral safety s

lukranit [14]

Answer:

Technician A is correct

Explanation:

The neutral safety switch when bad must be replaced and not adjusted as suggested by technician B because if the neutral safety switch is bad the Engine might not crank when put in neutral but it will crank when put in park and this is very bad for the life of the Engine it is better to replace it. A test for a bad/faulty neutral safety switch will be required to ascertain the level of damage it might cause to the Engine and prompt replacement is essential as well. because the neutral helps to prevent the car from starting when it is already engaged in a gear position therefore protecting the car from sudden collisions

3 0

2 years ago

Read 2 more answers

Saturated liquid-vapor mixture of water, called wet steam, in a steam line at 1500 kPa is throttled to 50 kPa and 100°C. What is

frozen [14]

Answer:

$x = 0.944$

Explanation:

Steam at outlet is an superheated steam, since $T > T_{sat}$ . From steam tables, the specific enthalpy is:

$h_{out}=2682.4\,\frac{kJ}{kg}$

The throttle valve is modelled after the First Law of Thermodynamics:

$h_{in} = h_{out}$

Hence, specific enthalpy at inlet is:

$h_{in}=2682.4\,\frac{kJ}{kg}$

The quality in the steam line is:

$x = \frac{2682.4\,\frac{kJ}{kg}-844.55\,\frac{kJ}{kg}}{2791.0\,\frac{kJ}{kg} - 844.55\,\frac{kJ}{kg} }$

$x = 0.944$

6 0

2 years ago