Examine the description of the EMPLOYEES table: Which query is valid?

Question

Exhibit

Options

• ASELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
• BSELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
• CSELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
• DSELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

• A
  4% (2)
• B
  72% (38)
• C
  9% (5)
• D
  15% (8)

No community discussion yet for this question.