Online Course Support

The 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.

Question 2
The 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 table reference in the FROM clause cannot have a dot ( .) in the name.
  • The expression in the WHERE clause must evaluate to a Boolean value
  • The expression in the WHERE clause must be in the SELECT list
  • The column in the WHERE clause is not in the SELECT list

Similar Posts