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

Question

Exhibit

Options

• ASELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
• BSELECT dept_id, AVG(MAX(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, join_date, SUM(salary) FROM employees GROUP BY dept_id;

• A
  5% (3)
• B
  2% (1)
• C
  7% (4)
• D
  86% (48)

No community discussion yet for this question.