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;