Question 6Which of the following would provide results that include a row with int_x=-25? Check all that apply. 1 point SELECT * FROM table_name WHERE int_x IN (-50, 0); SELECT…
Question 5The table table_name includes the following row: id bool1 bool2 bool334 true false trueWhich of the following would include that row in the result set? Check all that apply….
Question 4Select the expressions that are equivalent to x != 2 in SQL. Check all that apply. 1 point x < 2 OR x > 2 NOT x = 2…
Question 3Write and run a query on wax.crayons to find colors with 205 as the red value. Which of the following colors are returned? Check all that apply. 1 point…
Question 2The following query will fail: SELECT name, shop, aisle FROM fun.inventory WHERE price + 5; What are the issues with this query? Check all that apply. 1 point The…
Question 1For which of these tasks would you need to use a WHERE clause? Check all that apply. 1 point For a table of pets, including their owners and ages,…
Question 11Which of the following are true of keywords (such as SELECT and FROM) and identifiers (such as names of tables and columns) in Hive and Impala? Check all that…
Question 10You are working in the default database and want to list all the data in the crayons table, which is in the wax database. Which of the following allow…
Question 9The statement DESCRIBE workforce; has the following result: name type commentname stringoccupation stringsalary intWhich is the best statement to get a list of the occupations used in the table?…
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…
