Answer these question bellows. 1. Using drag and drop, complete the query below. The goal of the query is to display a list of customers from Utah, sorted by last name. SELECT lastname, firstname FROM customers (a) state = ‘UT’ (b) lastname A. SORT BY B. ORDER BY (b) C. WHEN D. WHERE (a) E. HAVING 2. Evaluate each statement regarding aggregates in queries. Select Yes if the statement is true and No if the statement is false. A. A GROUP BY clause must be paired with a HAVING clause. (NO) B. A GROUP BY clause must contain all non-aggregated fields in a (YES) query. C. A GROUP BY clause must be paired with a WHERE clause. (NO) 3. Evaluate the following SQL code: SELECT LastName, FirstName, COUNT(OrderID) FROM Customers GROUP BY LastName HAVING COUNT(OrderID) >=5 What would cause this statement to have a runtime error? A. A schema is missing. B. The GROUP BY clause is incomplete. C. A WHERE clause is required due to the presence of the HAVING clause. D. Semicolons are needed. 4. Evaluate the following SQL code: UPDATE Customers SET Status = 'Gold' IF TotalAmount > 10000 What would cause this statement to have a runtime error? A. The object type needs to be specified within the UPDATE statement B. The IF clause needs to be at the beginning of the statement C. The IF clause needs to be a WHERE clause D. The statement needs semicolons 5. Which statement will insert multiple rows? A. INSERT INTO table_name VALUES (value1, value2, value3,...) B. INSERT INTO table_name SELECT (column1, column2, column3) C. INSERT INTO table_name(column1, column2) VALUES (valuela, value1b), (value2a, value2b) D. INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...)