The fly.flights table has the following schema:

Question 1
The fly.flights table has the following schema:

column type
year smallint
month tinyint
day tinyint
dep_time smallint
sched_dep_time smallint
dep_delay smallint
arr_time smallint
sched_arr_time smallint
arr_delay smallint
carrier string
flight smallint
tailnum string
origin string
dest string
air_time smallint
distance smallint
Choose the valid SELECT statements. Check all that apply.

1 point

• SELECT * FROM fly.flights ORDER BY distance, air_time, delay;
• SELECT carrier, COUNT(*) FROM fly.flights GROUP BY carrier ORDER BY carrier;
• SELECT carrier, COUNT(*) FROM fly.flights ORDER BY carrier GROUP BY carrier;
• SELECT * FROM fly.flights ORDER BY distance;