2023 Name The goal of Test Week 3 is to assure that students have read and understood chapters | Assignment Collections

Name: _______________________________ (The goal of Test Week 3 is to assure that students have read and understood chapters 1, 2, 3, 4, 5) Give Syntax Example for each of the following Group Functions: (2 examples for each Function – each example for 1 points for total of 16 points – 2 * 8 = 16)   AVG SUM MIN MAX COUNT DISTINCT STDDEV VARIANCE   Provide 2 Syntax examples of using the GROUP BY Clause on Multiple Columns (2 examples each – each example for 3 points for total of 6 points)   Provide 2 Syntax examples of creating joins with the USING Clause (2 examples each – each example for 3 points for total of 6 points)   Provide 2 Syntax examples of the HAVING Clause with Subqueries (2 examples each – each example for 3 points for total of 6 points) Using the Employees and Departments tables below, provide the answer for Select Command using these tables. The goal is you walk though the Select Command on these tables manually and determine the answer (expected result) based on your reading of Chapter 1,2,3, 4, 5 from text book: (4 points – each question is for 16 points) – Just show the expected output when you run the syntax. EMPLOYEES Table End of EMPLOYEES Table DEPARTMENTS Table End of DEPARTMENTS Table What is the output when the following script is executed? SELECT AVG(salary), MAX(salary), MIN(salary), SUM(salary) FROM employees WHERE job_id LIKE ‘%REP%’; What is the output when the following script is executed? SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary >=10000 AND job_id LIKE ‘%MAN%’ ; What is the output when the following script is executed? SELECT employees.employee_id, employees.last_name, departments.location_id, department_id FROM employees JOIN departments USING (department_id) ; What is the output when…