Question 3Choose the best query to run in Impala to return the distinct union of the columns zip_plus_4 (type STRING, has values like ‘94306-0001’) in the california_emp table and zip…
Question 2Which of these queries produces the same result set as the following query? SELECT * FROM table1 UNION SELECT * FROM table2; 1 point SELECT * FROM table1 UNION…
Question 10In what order does a SQL engine execute the clauses of a SELECT statement? 1 point FROM, WHERE, SELECT, GROUP BY, HAVING, ORDER BY, LIMIT FROM, WHERE, GROUP BY,…
Question 9Select the appropriate uses for the LIMIT clause. Check all that apply. 1 point Filter individual rows based on conditions Protect against returning an unexpectedly large number of rows…
Question 8Which clause should you use with Impala to return rows 1001 through 1050 of a result set? 1 point OFFSET 1001,1050 OFFSET 1001 LIMIT 1050 LIMIT 1001,1050 LIMIT 50…
Question 7Select 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…
Question 6Select the queries that will run without error in Hive. Check all that apply. 1 point SELECT model FROM fly.planes ORDER BY type; SELECT model, year FROM fly.planes ORDER…
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 *…
