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

Which statement about direct-mail messages is most accurate? Group of answer choices Direct mail is an effective channel for per

torisob [31]

Answer:

Option A

Direct mail is an effective channel for personalized, tangible, three-dimensional messages that are less invasive than telephone solicitations

Explanation:

In modern days, we've seen email marketing hence option B that "Today's companies no longer send direct-mail messages to market their products or services; they rely exclusively on electronic media instead." These companies rely also on direct mails to their clients. Online marketing often uses direct mail for persuasion of their customers hence the last option is also wrong. Considering that already two statements are identified as inaccurate, the option that "All answer choices are accurate statements about direct-mail messages. " is misleading. Therefore, the only most accurate choice about direct-mail is option A

4 0

4 years ago

Christopher has designed a fluid power system that repeatedly gets clogs. Which of the following objects should he choose to add

MA_775_DIABLO [31]

Answer:

Valve

Explanation:

Its right

3 0

3 years ago

A pipeline (NPS = 14 in; schedule = 80) has a length of 200 m. Water (15℃) is flowing at 0.16 m3/s. What is the pipe head loss f

dangina [55]

Answer:

Head loss is 1.64

Explanation:

Given data:

Length (L) = 200 m

Discharge (Q) = 0.16 m3/s

According to table of nominal pipe size , for schedule 80 , NPS 14, pipe has diameter (D)= 12.5 in or 31.8 cm 0.318 m

We know, $head\ loss = \frac{f L V^2}{( 2 g D)}$

where, f = Darcy friction factor

V = flow velocity

g = acceleration due to gravity

We know, flow rate Q = A x V

solving for V

$V = \frac{Q}{A}$

$= \frac{0.16}{\frac{\pi}{4} (0.318)^2} = 2.015 m/s$

obtained Darcy friction factor

calculate Reynold number (Re) ,

$Re = \frac{\rho V D}{\mu}$

where, $\rho$ = density of water

$\mu$ = Dynamic viscosity of water at 15 degree C = 0.001 Ns/m2

so reynold number is

$Re = \frac{1000\times 2.015\times 0.318}{0.001}$

= 6.4 x 10^5

For Schedule 80 PVC pipes , roughness (e) is 0.0015 mm

Relative roughness (e/D) = 0.0015 / 318 = 0.00005

from Moody diagram, for Re = 640000 and e/D = 0.00005 , Darcy friction factor , f = 0.0126

Therefore head loss is

$HL = \frac{0.0126 (200)(2.015)^2}{( 2 \times 9.81 \times 0.318)}$

HL = 1.64 m

7 0

4 years ago

Of the core elements of successful safety and health programs,management leadership,worker participation and what else directly

ch4aika [34]

I think it would definitely be dinvi and the ghosts just because I really relate to that story

7 0

3 years ago

Calculate the force of attraction between a K+ and an O2- ion the centers of which are seperared by a distance of 1.5 nm.

Ymorist [56]

Answer:

$F=2.04\times 10^{-10} N$

Explanation:

Given that

$q_1=1\times 1.6\times 10^{-19}$

$q_2=2\times 1.6\times 10^{-19}$

r= 1.5 nm

We know that force between two charge given as follows

$F=K\dfrac{q_1q_2}{r^2}$

Where K is the constant

Noe by putting the values

$q_1\times q_2=2\times 1.6\times1.6\times 10^{-38}$

$F=8.98\times 10^9 \times \dfrac{5.12\times 10^{-38}}{\left ( 1.5\times10^{-9} \right )^2}$

$F=2.04\times 10^{-10} N$

8 0

3 years ago