Ask question

Ask question

All categories

3 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]3 years ago

6 0

Answer:

SELECT distinct VendorName FROM Vendors

WHERE VendorID IN (

SELECT VendorID FROM Invoices

)

Explanation:

You might be interested in

Question Completion Status:

Mashutka [201]

Answer: c. Centre of pressure

Explanation:

Pressure is applied on a surface when a force is exerted on a particular point on that surface by another object when the two come into contact with each other.

The point where the pressure is applied is known as the centre of the pressure with the force then spreading out from this point much like an epicentre in an earthquake.

6 0

3 years ago

A steel bar 100 mm long and having a square cross section 20 mm x 20 mm is pulled in

Ierofanga [76]

Answer:

222.5 Gpa

Explanation:

From definition of engineering stress, $\sigma=\frac {F}{A}$

where F is applied force and A is original area

Also, engineering strain, $\epsilon=\frac {\triangle l}{l}$ where l is original area and $\triangle l$ is elongation

We also know that Hooke's law states that $E=\frac {\sigma}{\epsilon}=\frac {\frac {F}{A}}{\frac {\triangle l}{l}}=\frac {Fl}{A\triangle l}$

Since A=20 mm* 20 mm= 0.02 m*0.02 m

F= 89000 N

l= 100 mm= 0.1 m

$\triangle l= 0.1 mm= 0.1\times 10^{-3} m$

By substitution we obtain

$E=\frac {89000\times 0.1}{0.02^{2}\times 0.1\times 10^{-3}}=2.225\times 10^{11}= 225.5 Gpa$

5 0

3 years ago

Find the differential and evaluate for the given x and dx: y=sin2xx,x=π,dx=0.25

Sedaia [141]

By applying the concepts of differential and derivative, the differential for y = (1/x) · sin 2x and evaluated at x = π and dx = 0.25 is equal to 1/2π.

<h3>How to determine the differential of a one-variable function</h3>

Differentials represent the <em>instantaneous</em> change of a variable. As the given function has only one variable, the differential can be found by using <em>ordinary</em> derivatives. It follows:

dy = y'(x) · dx (1)

If we know that y = (1/x) · sin 2x, x = π and dx = 0.25, then the differential to be evaluated is:

$y' = -\frac{1}{x^{2}}\cdot \sin 2x + \frac{2}{x}\cdot \cos 2x$

$y' = \frac{2\cdot x \cdot \cos 2x - \sin 2x}{x^{2}}$

$dy = \left(\frac{2\cdot x \cdot \cos 2x - \sin 2x}{x^{2}} \right)\cdot dx$

$dy = \left(\frac{2\pi \cdot \cos 2\pi -\sin 2\pi}{\pi^{2}} \right)\cdot (0.25)$

$dy = \frac{1}{2\pi}$

By applying the concepts of differential and derivative, the differential for y = (1/x) · sin 2x and evaluated at x = π and dx = 0.25 is equal to 1/2π.

To learn more on differentials: brainly.com/question/24062595

#SPJ1

4 0

2 years ago

A distillation column is initially designed to separate a mixture of toluene and xylene at around ambient temperature (say, 100°

weeeeeb [17]

Answer:

Purchase cost= 87056

Bar module cost= 292725

Explanation:

solution is attached below

6 0

4 years ago

A segment of four-lane freeway (two lanes in each direction) has a 3% upgrade that is 1500 ft long followed by a 1000-ft 4% upgr

Dennis_Churaev [7]

Answer:

The level of service of of compound grade freeway is LOSB.

Explanation:

Find the provided attachments for explanation

3 0

3 years ago