For each type of aircraft, display the total distance that can be flown before refueling. Display your results in descending order by the total distance that can be flown. SELECT COUNT( EQ_FUEL_CAPACITY) AS " TOTAL DISTANCE" FROM EQUIP_TYPE WHERE EQ_FUEL_CAPACITY < how do I display refueling? ORDER BY "TOTAL DISTANCE" DESC; Is it far out to the correct answer? give me a hand, please? 26. For each passenger listed in the PASSENGER table, display the name of the person responsible for his or her reservation.
25. For each type of aircraft, display the total distance that can be flown before refueling. Display your results in descending order by the total distance that can be flown.
SELECT COUNT( EQ_FUEL_CAPACITY) AS " TOTAL DISTANCE"
FROM EQUIP_TYPE
WHERE EQ_FUEL_CAPACITY < how do I display refueling?
ORDER BY "TOTAL DISTANCE" DESC;
Is it far out to the correct answer? give me a hand, please?
26. For each passenger listed in the PASSENGER table, display the name of the person responsible for his or her reservation.
SELECT PASS_NAME
FROM PASSENGER
WHERE? I do not understand responsible for her or his reservation?
WHERE PAS_CONFIRM_NO = RES_CONFIRM_NO ?
I cannot insert the code or script because it is too long. thank you
Trending now
This is a popular solution!
Step by step
Solved in 2 steps