Exhibit: Examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is…

Question

Exhibit

Options

• AThe SELECT statement is syntactically accurate.
• BThe SELECT statement does not work because there is no HAVING clause.
• CThe SELECT statement does not work because the column specified in the GROUP BY clause is
• DThe SELECT statement does not work because the GROUP BY clause should be in the main query

• A
  78% (28)
• B
  3% (1)
• C
  8% (3)
• D
  11% (4)

No community discussion yet for this question.