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

Two dogbone specimens of identical geometry but made of two different materials: steel and aluminum are tested under tension at

makkiz [27]

Answer:

$\dot L_{steel} = 3.448\times 10^{-4}\,\frac{in}{min}$

Explanation:

The Young's module is:

$E = \frac{\sigma}{\frac{\Delta L}{L_{o}} }$

$E = \frac{\sigma\cdot L_{o}}{\dot L \cdot \Delta t}$

Let assume that both specimens have the same geometry and load rate. Then:

$E_{aluminium} \cdot \dot L_{aluminium} = E_{steel} \cdot \dot L_{steel}$

The displacement rate for steel is:

$\dot L_{steel} = \frac{E_{aluminium}}{E_{steel}}\cdot \dot L_{aluminium}$

$\dot L_{steel} = \left(\frac{10000\,ksi}{29000\,ksi}\right)\cdot (0.001\,\frac{in}{min} )$

$\dot L_{steel} = 3.448\times 10^{-4}\,\frac{in}{min}$

7 0

2 years ago

Read 2 more answers

Determine the period of each of the following discrete-time signals (if a signal is not periodic, denote its period by infinity)

sergiy2304 [10]

Answer:

a) it is periodic

N = (20/3)k = 20 { for K =3}

b) it is Non-Periodic.

N = ∞

c) x(n) is periodic

N = LCM ( 5, 20 )

Explanation:

We know that In Discrete time system, complex exponentials and sinusoidal signals are periodic only when ( 2π/w₀) ratio is a rational number.

then the period of the signal is given as

N = ( 2π/w₀)K

k is least integer for which N is also integer

Now, if x(n) = x1(n) + x2(n) and if x1(n) and x2(n) are periodic then x(n) will also be periodic; given N = LCM of N1 and N2

now

a) cos(2π(0.15)n)

w₀ = 2π(0.15)

Now, 2π/w₀ = 2π/2π(0.15) = 1/(0.15) = 1×20 / ( 0.15×20) = 20/3

so, it is periodic

N = (20/3)k = 20 { for K =3}

b) cos(2n);

w₀ = 2

Now, 2π/w₀ = 2π/2) = π

so, it is Non-Periodic.

N = ∞

c) cos(π0.3n) + cos(π0.4n)

x(n) = x1(n) + x2(n)

x1(n) = cos(π0.3n)

x2(n) = cos(π0.4n)

so

w₀ = π0.3

2π/w₀ = 2π/π0.3 = 2/0.3 = ( 2×10)/(0.3×10) = 20/3

∴ N1 = 20

AND

w₀ = π0.4

2π/w₀ = 2π/π0. = 2/0.4 = ( 2×10)/(0.4×10) = 20/4 = 5

∴ N² = 5

so, x(n) is periodic

N = LCM ( 5, 20 )

6 0

3 years ago

Suppose a large amount of power is required. Which engine would you choose between Otto and Diesel? Why?

Firdavs [7]

Answer:

Otto engine

Explanation:

As we know that

Power = Torque x speed

So we can say that when speed of engine then power of engine also will increases.

The speed of Otto engine is more as compare to Diesel engine so the power of Otto engine is more.But on the other hand torque of Diesel engine is more as compare to Otto engine but the speed is low so the product of speed and torque is more for Otto engine .It means that when requires large amount of power then Otto engine should be use.

6 0

3 years ago

What type of cut is mainly done with the radial arm saw?

Dahasolnce [82]

Answer:

crosscut

Explanation:

8 0

1 year ago

What other ways could a wildfire be contained, extinguished, or slowed down?

galben [10]

Back burning, starting fires infront of the main fire to prevent the fire from spreading and depleting fuel for the fire, digging trenches so the fire has no where to go, dropping water from planes or helicopters.

3 0

2 years ago