Online Course Support

The table has the following schema:

Question 1
The 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 ORDER BY distance, air_time, delay;
  • SELECT carrier, COUNT(*) FROM GROUP BY carrier ORDER BY carrier;
  • SELECT carrier, COUNT(*) FROM ORDER BY carrier GROUP BY carrier;
  • SELECT * FROM ORDER BY distance;

Similar Posts