All categories

2 years ago

Write a SELECT statement that returns these four columns:

1 answer:

3 0

A SELECT command pulls zero or more rows from one or more database tables or views. SELECT is the most often used data manipulation language (DML) command in most applications. See the statement required below.

<h3>What is the SELECT Statement that gives the above results?</h3>

SELECT VendorName, InvoiceNumber, InvoiceDate,

InvoiceTotal - PaymentTotal - CreditTotal AS Balance

FROM Vendors JOIN Invoices

ON Vendors.VendorID = Invoices.VendorID

WHERE InvoiceTotal - PaymentTotal - CreditTotal > 0

ORDER BY VendorName;

Learn more about SELECT Statements at;

brainly.com/question/19338967
#SPJ1

You might be interested in

What are the philological elements of interior design most like?

sp2606 [1]

Answer:

Ea public address glven via the intercom system of a large buildingxplanation:

7 0

2 years ago

1. A glass window of width W = 1 m and height H = 2 m is 5 mm thick and has a thermal conductivity of kg = 1.4 W/m*K. If the inn

emmasim [6.3K]

Answer:

1. $\dot Q=19600\ W$

2. $\dot Q=120\ W$

Explanation:

Given:

height of the window pane, $h=2\ m$

width of the window pane, $w=1\ m$

thickness of the pane, $t=5\ mm= 0.005\ m$

thermal conductivity of the glass pane, $k_g=1.4\ W.m^{-1}.K^{-1}$

temperature of the inner surface, $T_i=15^{\circ}C$

temperature of the outer surface, $T_o=-20^{\circ}C$

<u>According to the Fourier's law the rate of heat transfer is given as:</u>

$\dot Q=k_g.A.\frac{dT}{dx}$

here:

A = area through which the heat transfer occurs = $2\times 1=2\ m^2$

dT = temperature difference across the thickness of the surface = $35^{\circ}C$

dx = t = thickness normal to the surface = $0.005\ m$

$\dot Q=1.4\times 2\times \frac{35}{0.005}$

$\dot Q=19600\ W$

air spacing between two glass panes, $dx=0.01\ m$

area of each glass pane, $A=2\times 1=2\ m^2$

thermal conductivity of air, $k_a=0.024\ W.m^{-1}.K^{-1}$

temperature difference between the surfaces, $dT=25^{\circ}C$

<u>Assuming layered transfer of heat through the air and the air between the glasses is always still:</u>

$\dot Q=k_a.A.\frac{dT}{dx}$

$\dot Q=0.024\times 2\times \frac{25}{0.01}$

$\dot Q=120\ W$

5 0

3 years ago

A. A 3-kg plastic tank that has a volume of 0.2 m^3 is lled with liquid water. Assuming the density of water is 1000 kg=m^3, det

Tpy6a [65]

Answer:

The answer is below

Explanation:

a) The weight of the combined system is the sum of the weight of the water and the weight of the tank

$m_{water}=V_{tank}.\rho_{wtaer}\\\\m_{water}=0.2m^3*1000kg/m^3\\\\m_{water}=200 \ kg\\\\m_{total} = m_{water}+m_{tank}\\\\But\ m_{tank}=3kg,therefore:\\\\m_{total} =200kg+3kg\\\\m_{total} =203\ kg\\\\weight_{total}=m_{total}g\\\\weight_{total}=203kg*9.81m/s^2\\\\weight_{total}=1991.43\ N$

b) Since the weight of a system can be divided into smaller portions, hence weight is an extensive property.

c) When analyzing the acceleration of gases as they flow through a nozzle, the geometry of the nozzle which is an open system can be chosen as our system.

d) Given that:

$\rho_{water}=1000kg/m^3\\\\1kg/m^3=0.062428lb/ft^3\\\\1000kg/m^3=1000kg/m^3*\frac{0.062428lb/ft^3}{kg/m^3}=62.43lb/ft^3\\ \\\rho=SG*\rho_{water}=1.03*62.43=64.272lb/ft^3\\\\P=P_{atm}+\rho g H\\\\P=14.7\ psia+64.272\ lb/ft^3*32.2\ ft/s^2*175\ ft*\frac{1\ ft^2}{12^2\ in^2}*\frac{1\ lbf}{32.2\ lbm.ft/s^2} \\\\P=92.8\ psia$