Consider the table gift given below: Table: gift
giftid
G101
G102
G103
G104
G105
G106
giftname
Magic Mug
Golf Set
Little Astronomer
Renoir Paintings
French Gastronomy
Magic Set
price
500
3550
2000
1500
3000
1300
discount availability
9
10
5
15
20
18
15
15
7
10
30
30
Query:
SELECT g1.giftid, g1.giftname FROM gift g1 JOIN gift g2
ON g1.availability=g2.availability AND g1.discount>g2.discount
WHERE g1.discount>7
How many rows will be fetched when the above query gets executed?

Abrake has a normal braking torque of 2.8 kip in and heat-dissipating cast-iron surfaces whose mass is 40 lbm. suppose a load is brought to rest in 8.0 s from an initial angular speed of 1600 rev/min using the normal braking torque; estimate the temperature rise of the heat dissipating surfaces.

Asingle-geared blanking press has a stroke of 200 mm and a rated capacity of 320 kn. a cam driven ram is assumed to be capable of delivering the full press load at constant force during the last 15 percent of a constant-velocity stroke. the camshaft has an average speed of 90 rev/min and is geared to the flywheel shaft at a 6: 1 ratio. the total work done is to include an allowance of 16 percent for friction a) estimate the maximum energy fluctuation b) find the rim weight for an effective diameter of 1.2 m and a coefficient of speed fluctuation of 0.10

For the closed feedwater heater below, feedwater enters state 3 at a pressure of 2000 psia and temperature of 420 °f at a rate of ix10 ibhr. the feedwat extracted steam enters state 1 at a pressure of 1000 psia and enthalpy of 1500 btu/lbm. the extracted er leaves at an enthalpy of 528.7 btu/lbm steam leaves as a saturated liquid. (16) a) determine the mass flow rate of the extraction steam used to heat the feedwater (10) b) determine the terminal temperature difference of the closed feedwater heater