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

If block A of the pulley system is moving downward at 6 ft>s while block C is moving down at 18 ft>s, determine the relati

kramer

Answer:

Explanation:

The detailed steps and appropriate calculation with analysis is as shown in the attachment.

3 0

3 years ago

Select the correct answer.

cricket20 [7]

Answer:

A.

The power generated by a wind farm is not constant because of irregular wind patterns.

5 0

3 years ago

Koch traded Machine 1 for Machine 2 when the fair market value of both machines was $60,000. Koch originally purchased Machine 1

Mariana [72]

Answer:

Koch's adjusted basis in machine 2 after the exchange is $60,000

Explanation:

given data

fair market value = $60,000

originally purchased Machine 1 = $76,900

Machine 1 adjusted basis = $40,950

Machine 2 seller purchase = $64,050

Machine 2 adjusted basis = $55,950

solution

As he exchanged machine for another at $60,000

and this exchanged in fair market

so adjusted basis = $50,000

Adjusted basis is the price of the item that affects the factors that are considered price. These factors usually include taxes, depreciation value, and other costs of acquiring and maintaining a given item. Adjusted basis is important so the right amount to sell

Adjusted basis increases when a person deducts expenses from factor taxes and operating statements

so Koch's adjusted basis in machine 2 after the exchange is $60,000

3 0

3 years ago

Two substances, A and B, initially at different temperatures, come into contact and reach thermal equilibrium. The mass of subst

Kaylis [27]

Answer:

The specific heat capacity of substance A is 1.16 J/g

Explanation:

The substances A and B come to a thermal equilibrium, therefore, the heat given by the hotter substance B is absorbed by the colder substance A.

The equation becomes:

Heat release by Substance B = Heat Gained by Substance A

The heat can be calculated by the formula:

Heat = mCΔT

where,

m = mass of substance

C = specific heat capacity of substance

ΔT = difference in temperature of substance

Therefore, the equation becomes:

(mCΔT) of A = (mCΔT) of B

<u>FOR SUBSTANCE A:</u>

m = 6.01 g

ΔT = Final Temperature - Initial Temperature

ΔT = 46.1°C - 20°C = 26.1°C

C = ?

<u>FOR SUBSTANCE B:</u>

m = 25.6 g

ΔT = Initial Temperature - Final Temperature

ΔT = 52.2°C - 46.1°C = 6.1°C

C = 1.17 J/g

Therefore, eqn becomes:

(6.01 g)(C)(26.1°C) = (25.6 g)(1.17 J/g)(6.1°C)

C = (182.7072 J °C)/(156.861 g °C)

<u>C = 1.16 J/g</u>

5 0

3 years ago

Steam enters a two-stage adiabatic turbine at 8 MPa and 5008C. It expands in the first stage to a state of 2 MPa and 3508C. Stea

Nataly [62]

Answer:

1) The exergy of destruction is approximately 456.93 kW

2) The reversible power output is approximately 5456.93 kW

Explanation:

1) The given parameters are;

P₁ = 8 MPa

T₁ = 500°C

From which we have;

s₁ = 6.727 kJ/(kg·K)

h₁ = 3399 kJ/kg

P₂ = 2 MPa

T₂ = 350°C

From which we have;

s₂ = 6.958 kJ/(kg·K)

h₂ = 3138 kJ/kg

P₃ = 2 MPa

T₃ = 500°C

From which we have;

s₃ = 7.434 kJ/(kg·K)

h₃ = 3468 kJ/kg

P₄ = 30 KPa

T₄ = 69.09 C (saturation temperature)

From which we have;

h₄ = $h_{f4}$ + x₄× $h_{fg}$ = 289.229 + 0.97*2335.32 = 2554.49 kJ/kg

s₄ = $s_{f4}$ + x₄× $s_{fg}$ = 0.94394 + 0.97*6.8235 ≈ 7.563 kJ/(kg·K)

The exergy of destruction, $\dot X_{dest}$ , is given as follows;

$\dot X_{dest}$ = T₀ × $\dot S_{gen}$ = T₀ × $\dot m$ × (s₄ + s₂ - s₁ - s₃)

$\dot X_{dest}$ = T₀ × $\dot W$ ×(s₄ + s₂ - s₁ - s₃)/(h₁ + h₃ - h₂ - h₄)

∴ $\dot X_{dest}$ = 298.15 × 5000 × (7.563 + 6.958 - 6.727 - 7.434)/(3399 + 3468 - 3138 - 2554.49) ≈ 456.93 kW

The exergy of destruction ≈ 456.93 kW

2) The reversible power output, $\dot W_{rev}$ = $\dot W_{}$ + $\dot X_{dest}$ ≈ 5000 + 456.93 kW = 5456.93 kW

The reversible power output ≈ 5456.93 kW.

6 0

3 years ago