Examine the description of the EMPLOYEES table: (Exhibit) Which query is valid? By Singh | January 1, 2023 0 Comment Examine the description of the EMPLOYEES table:Which query is valid? A. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date; B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id; C. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id; D. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id; Correct Answer: B