Select the valid SQL queries. Check all that apply.
Question 7
Select the valid SQL queries. Check all that apply.
1 point
SELECT arr_time, AVG(arr_delay) AS avg_arr_delay
FROM flights WHERE origin = ‘LAX’
GROUP BY arr_time
HAVING avg_arr_delay > 45
LIMIT 1000;
SELECT arr_time, AVG(arr_delay) AS avg_arr_delay
FROM flights WHERE origin = ‘LAX’
GROUP BY arr_time
HAVING avg_arr_delay > 45
LIMIT -100;
SELECT arr_time, AVG(arr_delay) AS avg_arr_delay
FROM flights WHERE origin = ‘LAX’
LIMIT 100
GROUP BY arr_time
HAVING avg_arr_delay > 45;
SELECT arr_time, AVG(arr_delay) AS avg_arr_delay
FROM flights LIMIT 100
WHERE origin = ‘LAX’
GROUP BY arr_time
HAVING avg_arr_delay > 45;
SELECT arr_time, AVG(arr_delay) AS avg_arr_delay, 100 AS row_limit
FROM flights WHERE origin = ‘LAX’
GROUP BY arr_time
HAVING avg_arr_delay > 45
LIMIT row_limit;