Question 1The fly.flights table has the following schema: column typeyear smallintmonth tinyintday tinyintdep_time smallintsched_dep_time smallintdep_delay smallintarr_time smallintsched_arr_time smallintarr_delay smallintcarrier stringflight smallinttailnum stringorigin stringdest stringair_time smallintdistance smallintChoose the valid SELECT statements….
Question 10Choose 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…
Question 8Which SELECT statements will return the same result as SELECT COUNT(type) AS num_types FROM fly.planes; Check all that apply. 1 point SELECT COUNT(*) AS num_types FROM fly.planes; SELECT COUNT(DISTINCT…
Question 7For a table of students enrolled at a college, the query SELECT MIN(age) FROM students; gave one row in the results, with only one column. The value was 16….
Question 4Here is the default.orders table: order_id cust_id empl_id total1 c 1 24.782 a 4 28.543 b 3 48.694 b 3 -16.395 z 2 29.92How many columns and rows does…
Question 2Which of the following statements are valid? (The column color is a string column, and both red and blue are integer columns.) Check all that apply. 1 point SELECT…
Question 10You have a database in which some bad data in the column named score is marked with NULL and some is marked with the value -1. For your purposes,…
Question 9The following shows Amaal Al-Amin’s data from a table for students in a school. (GPA is grade point average, where 4.0 means the student is getting the highest scores…
Question 8The offices table in the default database on the VM includes one row with NULL in state_province column. Which of the following would provide that row in the result?…
Question 7The following shows just a few rows from a table for students in a school. (GPA is grade point average, where 4.0 means the student is getting the highest…
