blog

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…

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 b​ool33​4 t​rue f​alse t​rueWhich 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…