Q8. Which query requires explicit data type conversion?

Q8. Examine the description of the EMPLOYEES table:

NLS_DATE_FORMAT is set to DD-MON-YY.

Which query requires explicit data type conversion?

• (A). SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
• (B). SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
• (C). SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
• (D). SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;