Question 8Suppose you want to calculate when each game in the fun.games table celebrated its 10th anniversary. (For information about this table, see the result of the DESCRIBE statement in…
Question 6Consider this query: SELECT game, shop, price, round(0.08*price,2) AS tax FROM fun.inventory; Which are the correct column names in the header of the result set for this query? 1…
Question 5The result of DESCRIBE fun.games; gives this result: name type commentid intname stringinventor stringyear stringmin_age tinyintmin_players tinyintmax_players tinyintlist_price decimal(5,2)Assume you are using Impala, which does not implicitly cast data…
Question 3The customers table in the default database has columns cust_id, name, and country (all string types). Which of the following are valid SELECT statements? Check all that apply. 1…
Question 2Which of the following can be achieved using a SELECT statement with Hive or Impala? Check all that apply. 1 point Displaying the output of an expression Loading a…
1.Question 1Which is the best description of the SELECT statement in SQL? (Note, this is not referring to the SELECT list.) 1 point The statement most often used to define…
Question 4Which of the following provide a user interface where you can enter and run SQL queries? Check all that apply. 1 point Hue Linux JDBC Impala Shell SQuirreL SQL…
Question 3What are the steps to run a SELECT statement in Hue? 1 point Navigate to the Table Browser and click on the table you want to use. Enter the…
Question 2Which steps in Hue will list the tables within a database? 1 point Use the active database selector to change to the database, and then run SHOW TABLES Run…
Question 1Which best describes what the circled area in the following screen capture is used for? 1 point Clicking on a database name and seeing what tables are in the…
