【单选题】
A SELECT dept_id,AVG(salary) FROM employees GROUP BY dept_id WHERE AVG(salary) >5000
B SELECT dept_id,AVG(salary) FROM employees GROUP BY dept_id HAVING AVG(salary) >5000
C SELECT dept_id,AVG(salary) FROM employees WHERE AVG(salary)>5000 GROUP BY dept_id
D SELECT dept_id,AVG(salary) FROM employees HAVING AVG(salary) >5000 GROUP BY dept_id
查看更多