Ask question

Ask question

All categories

Nadusha1986 [10]

3 years ago

11

Given a books table with columns named book_title and year_released, the following SQL statement will select the number of books

released each year. SELECT book_title, year_released FROM books GROUP BY year_released;

1 answer:

lord [1]3 years ago

8 0

Question Continuation

True or False?

Answer:

False

Explanation:

Given

Columns: book_title and year_released

SQL statement: SELECT book_title, year_released FROM books GROUP BY year_released

Expected Result: To select the number of books released each year

Although the GROUP BY used in the SQL statement is meant to group rows with same values into summary rows but it's not user properly because the GROUP BY clause, as used here needs the COUNT aggregate functions to group the result-set by one or more columns.

You might be interested in

Six forces act on a beam that forms part of a building's

IrinaVladis [17]

Answer:

<h2> FA = 13 kN </h2><h2>FG = 15.3 kN</h2>

Explanation:

write each force in terms of magnitude and directions

Fx = F sin Ф

Fy = F cos Ф

where Ф is to be measured from x axis.

∑F at y = o

FAy + FBy + FCy + FDy + FEy + FGy = 0

∑F at x = o

FAx + FBx + FCx + FDx + FEx + FGx = 0

Let

FA = FA sin (110) + FA cos (110)

FB = 20 sin (270) + 20 cos (270)

FC = 16 sin (140) + 16 cos (140)

FD = 9 sin (40) + 9 cos (40)

FE = 20 sin (270) + 20 cos (270)

FG = FG sin (50) + FG cos (50)

add x and y forces:

FAx + FBx + FCx + FDx + FEx + FGx = 0

FAy + FBy + FCy + FDy + FEy + FGy = 0

FA sin (110) + 0 + 16 sin (140) + 9 sin (40) + 0 + FG sin (50) = 0

FA cos (110) - 20 + 16 cos (140) + 9 cos (40) - 20 + FG cos (50 = 0

FA sin (110) + 0 + 10.285 + 5.785 + 0 + FG sin (50) = 0

FA cos (110) - 20 - 12.257 + 6.894 - 20 + FG cos (50) = 0

FA sin (110) + 16.070 + FG sin (50) = 0

FA cos (110) - 45.363 + FG cos (50) = 0

solving for FA, and FG

FA = 13 kN

FG = 15.3 kN

7 0

3 years ago

What does snow fall from?

Klio2033 [76]

Answer:

Clouds

Explanation:

It is created by trapped dust and water.

4 0

3 years ago

A four-cylinder, four-stroke internal combustion engine has a bore of 3.7 in. and a stroke of 3.4 in. The clearance volume is 16

Bad White [126]

Answer:

the net work per cycle $\mathbf{W_{net} = 0.777593696}$ Btu per cycle

the power developed by the engine, W = 88.0144746 hp

Explanation:

the information given includes;

diameter of the four-cylinder bore = 3.7 in

length of the stroke = 3.4 in

The clearance volume = 16% = 0.16

The cylindrical volume $V_2 = 0.16 V_1$

the crankshaft N rotates at a speed of 2400 RPM.

At the beginning of the compression , temperature $T_1$ = 60 F = 519.67 R

and;

Otto cycle with a pressure = 14.5 lbf/in² = (14.5 × 144 ) lb/ft²

= 2088 lb/ft²

The maximum temperature in the cycle is 5200 R

From the given information; the change in volume is:

$V_1-V_2 = \dfrac{\pi}{4}D^2L$

$V_1-0.16V_1= \dfrac{\pi}{4}(3.7)^2(3.4)$

$V_1-0.16V_1= 36.55714291$

$0.84 V_1 =36.55714291$

$V_1 =\dfrac{36.55714291}{0.84 }$

$V_1 =43.52040823 \ in^3 \\ \\ V_1 = 43.52 \ in^3$

$V_1 = 0.02518 \ ft^3$

the mass in air ( lb) can be determined by using the formula:

$m = \dfrac{P_1V_1}{RT}$

where;

R = 53.3533 ft.lbf/lb.R°

$m = \dfrac{2088 \ lb/ft^2 \times 0.02518 \ ft^3}{53.3533 \ ft .lbf/lb.^0R \times 519 .67 ^0 R}$

m = 0.0018962 lb

From the tables of ideal gas properties at Temperature 519.67 R

$v_{r1} =158.58$

$u_1 = 88.62 Btu/lb$

At state of volume 2; the relative volume can be determined as:

$v_{r2} = v_{r1} \times \dfrac{V_2}{V_1}$

$v_{r2} = 158.58 \times 0.16$

$v_{r2} = 25.3728$

The specific energy $u_2$ at $v_{r2} = 25.3728$ is 184.7 Btu/lb

From the tables of ideal gas properties at maximum Temperature T = 5200 R

$v_{r3} = 0.1828$

$u_3 = 1098 \ Btu/lb$

To determine the relative volume at state 4; we have:

$v_{r4} = v_{r3} \times \dfrac{V_1}{V_2}$

$v_{r4} =0.1828 \times \dfrac{1}{0.16}$

$v_{r4} =1.1425$

The specific energy $u_4$ at $v_{r4} =1.1425$ is 591.84 Btu/lb

Now; the net work per cycle can now be calculated as by using the following formula:

$W_{net} = Heat \ supplied - Heat \ rejected$

$W_{net} = m(u_3-u_2)-m(u_4 - u_1)$

$W_{net} = m(u_3-u_2- u_4 + u_1)$

$W_{net} = m(1098-184.7- 591.84 + 88.62)$

$W_{net} = 0.0018962 \times (1098-184.7- 591.84 + 88.62)$

$W_{net} = 0.0018962 \times (410.08)$

$\mathbf{W_{net} = 0.777593696}$ Btu per cycle

the power developed by the engine, in horsepower. can be calculated as follows;

In the four-cylinder, four-stroke internal combustion engine; the power developed by the engine can be calculated by using the expression:

$W = 4 \times N' \times W_{net$

where ;

$N' = \dfrac{2400}{2}$

N' = 1200 cycles/min

N' = 1200 cycles/60 seconds

N' = 20 cycles/sec

W = 4 × 20 cycles/sec × 0.777593696

W = 62.20749568 Btu/s

W = 88.0144746 hp

8 0

3 years ago

Ammonia contained in a piston-cylinder assembly, initially saturated vapor at 0o F, undergoes an isothermal process during which

Rudik [331]

ANSWERS:

$-P_{2(a)} =15.6lbf/in^2\\-P_{2(b)} =30.146lbf/in^2\\ T_{2(a)} =0^oF\\T_{2(b)} =0^oF\\x_{2(b)} =49.87percent$

Explanation:

Given:

Piston cylinder assembly which mean that the process is constant pressure process P=C.

<u>AMMONIA </u>

state(1)

saturated vapor $x_{1} =1$

The temperature $T_{1} =0^0 F$

Isothermal process $T=C$

a)

$-V_{2} =2V_{1}$ ( double)

b)

$-V_{2} =.5V_{2}$ (reduced by half)

To find the final state by giving the quality in lbf/in we assume the friction is neglected and the system is in equilibrium.

state(1)

using PVT data for saturated ammonia

$-P_{1} =30.416 lbf/in^2\\-v_{1} =v_{g} =9.11ft^3/lb$

then the state exists in the supper heated region.

a) from standard data

$-v_{1(a)} =2v_{1} =18.22ft^3/lb\\-T_{1} =0^oF$

$at\\P_{x} =14lbf/in^2\\-v_{x} =20.289 ft^3/kg$

$at\\P_{y} =16 lbf/in^2\\-v_{y} =17.701ft^3/kg$

assume linear interpolation

$\frac{P_{x}-P_{2(b)} }{P_{x}- P_{y} } =\frac{v_{x}-v_{1(a)} }{v_{x}-v_{y} }$

$P_{1(b)}=P_{x} -(P_{x} -P_{y} )*\frac{v_{x}- v_{1(b)} }{v_{x}-v_{y} }\\ \\P_{1(b)} =14-(14-16)*\frac{20.289-18.22}{20.289-17.701} =15.6lbf/in^2$

b)

$-v_{2(a)} =2v_{1} =4.555ft^3/lb\\v_{g}$

from standard data

$-v_{f} =0.02419ft^3/kg\\-v_{g} =9.11ft^3/kg\\v_{f}$

then the state exist in the wet zone

$-P_{s} =30.146lbf/in^2\\v_{2(a)} =v_{f} +x(v_{g} -v_{f} )$

$x=\frac{v_{2(a)-v_{f} } }{v_{g} -v_{f} } \\x=\frac{4.555-0.02419}{9.11-0.02419} =49.87%$

3 0

3 years ago

Engineers are designing a cylindrical air tank and are trying to determine the dimensions of the tank. The proposed material for

lana66690 [7]

Answer:

The length of tank is found to be 0.6 m or 600 mm

Explanation:

In order to determine the length, we need to find a volume for the tank.

For this purpose, we use ideal gas equation:

PV = nRT

n = no. of moles = m/M

Therefore,

PV = (m/M)(RT)

V = (mRT)/(MP)

where,

V = volume of air = volume of container

m = mass of air = 4.64 kg

R = General Gas Constant = 8.314 J/mol.k

T = temperature of air = 10°C + 273 = 283 K

M = molecular mass of air = 0.02897 kg/mol

P = Pressure of Air = 20 MPa = 20 x 10^6 N/m²

V = (4.64 kg)(8.314 J/mol.k)(283 k)/(0.02897 kg/mol)(20 x 10^6 N/m²)

V = 0.01884 m³

Now, the volume of cylindrical tank is given as:

V = 0.01884 m³ = π(Diameter/2)²(Length)

Length = (0.01884 m³)(4)/π(0.2 m)²

<u>Length = 0.6 m = 600 mm</u>

4 0

3 years ago