blog

Question 5Select the queries that will return exactly the same result as the query: SELECT * FROM fly.planes ORDER BY year DESC; when executed by Impala. Check all that apply….

Question 4Write and run a SQL query to determine which airport in the fly.airports table is closest to the geographical (not magnetic) North Pole, using the following calculation for the…

Question 2Select all the statements that return the same result as SELECT * FROM flights ORDER BY carrier; 1 point SELECT * FROM flights ORDER BY carrier ASC; SELECT *…

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,…