不忘初心,砥砺前行 Oracle EMPLOYEES表，以下哪个查询是有效的？ A.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id,join_date; B.SELECT dept_id,MAX (AVG (salary)) FROM employees GROUP BY dept_id; C.SELECT dept_ id,AVG (MAX (salary)) FROM employees GROUP BY dapt_id; D.SELECT depe_id,join_date, SUM(salary) FROM employees GROUP BY dept_id: