Problem Statement

Question 1 As a database analyst at an online retailer, working on the customer-profile system, pick the correct explanation of this query from the system: SELECT * FROM users clients Selects everything in the "users" table, then adds columns from the "clients" table. If the "users" table exists, selects everything from there. Otherwise, queries the "clients" table as a fallback. Selects everything in the "users" table, then assigns the "clients" alias. Selects everything in the "users" table, then adds rows from the "clients" table. Question 2 As a data analyst at an online retailer looking into product-category performance metrics, you need to spot problematic SQL queries. Pick the expression that throws a MySQL error when run against the category database. SELECT AVG( id ) FROM categories SELECT AVG( id ) FROM categories GROUP BY type SELECT 'average', AVG( id ) FROM categories GROUP BY 1 None of the above, all expressions are correct Question 3 As a customer-data analyst at an onli