Ask question

Ask question

All categories

3 years ago

10

Considering the two tables below called Orders and OrderLines, how many rows would be returned by this SQL query? SELECT o.Order

ID, ol.OrderLineID FROM Orders AS o LEFT JOIN OrderLines AS ol ON o.OrderID = ol.OrderID ;

1 answer:

natima [27]3 years ago

3 0

Answer:

The query will return four (4) rows

Explanation:

(See attachment below for the table)

The query will return rows where ORDERID is the same on both tables i.e. table ORDERS and ORDERLINES.

The similar rows (on column ORDERID) are 1897 and 87; for table ORDERLINESS and table ORDERS.

But on table ORDERLINESS, there are three rows with 1897 (under ORDERID column).

In total, they have 4 rows in common which are

ORDERID

1897

1897

1897 and

87

You might be interested in

Problem 2. The length of a side of the square block is 4 in. Under the application of the load V, the top edge of the block disp

White raven [17]

Answer and Explanation:

The answer is attached below

8 0

3 years ago

In an air standard diesel cycle compression starts at 100kpa and 300k. the compression ratio is 16 to 1. The maximum cycle tempe

KIM [24]

Answer:

$\eta$ =0.60

Explanation:

Given :Take $\gamma$ =1.4 for air

$P_1=100 KPa ,T_1=300K$

$\frac{V_1}{V_2}$ =r ⇒ r=16

As we know that

$T_2=T_1(r^{\gamma-1})$

So $T_2=300\times 16^{\gamma-1}$

$T_2$ =909.42K

Now find the cut off ration $\rho$

$\rho=\frac{V_3}{V_2}$

$\frac{V_3}{V_2}=\frac{T_3}{T_2}$

$\rho=\frac{2031}{909.42}$

$\rho=2.23$

So efficiency of diesel engine

$\eta =1-\dfrac{\rho^\gamma-1}{\gamma\times r^{\gamma-1}(\rho-1)}$

Now by putting the all values

$\eta =1-\dfrac{2.23^{1.4}-1}{1.4\times 16^{1.4-1}(2.23-1)}$

So $\eta$ =0.60

So the efficiency of diesel engine=0.60

7 0

3 years ago

A simple formula to estimate the upward velocity of a rocket (neglecting the aerodynamic drag) is:

Bingel [31]

Answer:

Test code:

>>u=10;

>>g=9.8;

>>q=100;

>>m0=100;

>>vstar=10;

>>tstar=fzero_rocket_example(u, g, q, m0, vstar)

Explanation:

See attached image

5 0

3 years ago

An ac waveform has an RMS voltage of 60 back. What is the waveforms peak voltage? A. 68.8 vac B. 84.4 vac 46.9 vac 60.0 vac

yawa3891 [41]

Answer:A

Explanation:I think it is

7 0

3 years ago

A cylindrical buoy is 2m in diameter and 2.5m long and weight 22kN . The specific weight of sea water is 10.25kN/m^3 . (I) Show

aleksandrvk [35]

Answer:

$GM$

So the bouy does not float with its axis vertical

Explanation:

From the question we are told that:

Diameter $d=2m$

Length $l=2.5m$

Weight $W=22kN$

Specific weight of sea water $\mu= 10.25kN/m^3$

Generally the equation for weight of cylinder is mathematically given by

Weight of cylinder = buoyancy Force

$W=(pwg)Vd$

Where

$V_d=\pi/4(d)^2y$

Therefore

$22*10^3=10.25*10^3 *\pi/4(2)^2y\\\\\22*10^3=32201.3247y\\\\\y=1.5m$

Therefore

Center of Bouyance B

$B=\frac{y}{2}=0.26m\\\\B=0.75$

Center of Gravity

$G=\frac{I.B}{2}=2.6m$

Generally the equation for\BM is mathematically given by

$BM=\frac{I}{vd}\\\\BM=\frac{3.142/64*2^4}{3.142/4*2^2*0.5215}\\\\BM=0.479m\\\\$

Therefore

$BG=2.6-0.476\\\\BG=0.64m$

Therefore

$GM=BM-BG\\\\GM=0.479m-0.64m\\\\GM=-0.161m\\\\$

Therefore

$GM$

So the bouy does not float with its axis vertical

4 0

3 years ago