Problem Statement

Pick the expression below that MySQL would reject with an error. SELECT 1, 2, 3 SELECT 1 2 3 SELECT '1 2 3' None of the above, all expressions are correct Pick the expression(s) below whose syntax is valid for operating on a table. DROP TABLE IF EXISTS users DELETE TABLE IF EXISTS users DROP TABLE users DESTROY TABLE users Among the options below, which lists SQL clause execution order in the most standard way? (Note: the true logical order begins with FROM, so choose the option that best reflects the conventional representation.) SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY SELECT, FROM, GROUP BY, WHERE, HAVING, ORDER BY FROM, GROUP BY, WHERE, ORDER BY, HAVING, SELECT SELECT, FROM, GROUP BY, HAVING, WHERE, ORDER BY In this set of more advanced queries, mark every expression that MySQL would reject with an error. SELECT customer_id, COUNT(*) FROM transactions GROUP BY customer_id HAVING COUNT(*) > 10 SELECT customer_id, COUNT(*) AS transactions FROM transactions GROUP BY cu