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;