1Z0-071 Web TestEngine demo

Examine the description of the EMPLOYEES table:

Which two queries will execute successfully? (Choose two.)

Select all that apply.

• A

  SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id HAVING hire_date > '01-
  JAN-19';

• B

  SELECT dept_id, SUM(salary) FROM employees WHERE hire_date > '01-JAN-19' GROUP BY
  dept_id;

• C

  SELECT dept_id, MAX(SUM(salary)) FROM employees GROUP BY dept_id;

• D

  SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id, salary;

• E

  SELECT AVG(MAX(salary)) FROM employees GROUP BY salary;