7.查看以下成功执?的语句： SELECT d.department_name,ROUND(AVG(NULLIF(e.salary,0)))AS
avgsal,MAX(e.salary)AS maxsal
FROM employees e
JOIN departments d
ON(e.department_id=d.department_id)
GROUP BY d.department_name
ORDER BY 2；
发布于 2021-01-29 12:31:14
【多选题】 A A.按MAXSAL排序 B B.按AVGSAL排序 C department_name maxsal D D.按DEPARTMENT_NAME和AVGSAL排序 E E.按DEPARTMENT_NAME排序
