Employee的表结构为:职工号、单位号、工资,查询至少有5名职工的每个单位的人数和最高工资,结果按工资降序排序。正确的SQL命令是
A.
SELECT 单位号,COUNT(*),MAX(工资) FROM Employee GROUP BY 单位号; WHERE COUNT(*)>=5 ORDER BY 3 DESC
B.
SELECT 单位号,COUNT(*),MAX(工资) FROM Employee ORDER BY 单位号; HAVING COUNT(*)>=5 ORDER BY 3 DESC
C.
SELECT 单位号,MAX(工资) FROM Employee GROUP BY 单位号; HAVING COUNT(*)>=5 ORDER BY 3 DESC
D.
SELECT 单位号,COUNT(*),MAX(工资) FROM Employee; GROUP BY 单位号 HAVING COUNT(*)>=5 ORDER BY 3 DESC