Question 4 (3 points) A query is limited to a single aggregate calculation in its SELECT clause. True False Question 5 (3 points) The GROUP BY clause groups the rows of a result set based on one or more columns or expressions. In the example below, what will the value from COUNT() represent? SELECT Department, COUNT (*) FROM EMPLOYEES GROUP BY Department: The total number of employees in each department The total number of employees The total number of departments The total number departments for each employee Question 6 (3 points) Specify the correct order in which each of the six SQL clauses must be placed: FROM 1 HAVING 2 3 4 WHERE GROUP BY ORDER BY SELECT 6 Question 7 (3 points) The GROUP BY clause can contain more than one value (separated by commas). In the query below, what does SUM(Salary) represent? SELECT Department, State, SUM (Salary) FROM EMPLOYEES GROUP BY Department, Statei The total salary budget for the organization The salary budget for each state The salary budget for each department The salary budget for each combination of department and state Question 8 (3 points) The WHERE clause and the HAVING clause can both limit rows in the result set based on logical conditions. What is the difference between the two clauses? HAVING cannot use the logical OR operator WHERE is limited to a single condition HAVING can make comparisons against aggregate functions WHERE requires a corresponding GROUP BY Question 9 (3 points) Conditions comparing against non-aggregate values must be placed in the WHERE clause (never in the HAVING clause) True False Question 10 (3 points) What is the ROLLUP operator used for in the GROUP BY clause? To add a summary total for each grouping To save memory in query execution To group based on unique values To group by all values-even if they do not match WHERE clause conditions