Online Course Support

Choose the SELECT statement that returns a result set describing, for each carrier, the average air time for the flights that have a departure delay longer than the flight’s air time, and only for carriers with more than 70,000 of those flights.

Question 10
Choose the SELECT statement that returns a result set describing, for each carrier, the average air time for the flights that have a departure delay longer than the flight’s air time, and only for carriers with more than 70,000 of those flights.

1 point

SELECT carrier, AVG(air_time) FROM flights

GROUP BY carrier

WHERE dep_delay > air_time

HAVING COUNT(*) > 70,000;

SELECT carrier, AVG(air_time) FROM flights

WHERE dep_delay > air_time

GROUP BY carrier HAVING count(*) > 70000;

SELECT carrier, AVG(air_time) FROM flights

GROUP BY carrier

HAVING dep_delay > air_time AND COUNT(*) > 70,000;

SELECT carrier, AVG(air_time) FROM flights

WHERE dep_delay > air_time AND COUNT(*) > 70,000

GROUP BY carrier;

Similar Posts