SQL - Fuel per hour

see attachment

Modify the query in Problem 1 above to include the computed (derived) attribute “fuel per hour.” (Hint: It is possible to use SQL to produce computed “attributes” that are not stored in any table. For example, the following SQL query is perfectly acceptable:
SELECT CHAR_DISTANCE, CHAR_FUEL_GALLONS/CHAR_DISTANCE
FROM CHARTER;
(The above query produces the “gallons per mile flown” value.) Use a similar technique on joined tables to produce the “gallons per hour” output shown in the figure below. (Note that 67.2 gallons/1.5 hours produces 44.8 gallons per hour.)

Attached file(s):

query4.doc  View File