查询持有外币种类在4种以上人员的姓名,及持有的种类数量,并按种类数量升序排列,数量相同时,则按姓名降序排列,下列语句正确的是( )。
A. SELECT 姓名,COUNT(*)AS外币种类 FROM 持有数;GROUP BY 姓名 HAVING COUNT(*)>=4;ORDER BY 外币种类,姓名 DESC
B. SELECT 姓名,COUNT(*)AS 外币种类 FROM 持有数;GROUP BY 姓名 HAVING COUNT(*)>=4;ORDER BY COUNT(*),姓名 DESC
C. SELECT 姓名,COUNT(*)AS 外币种类 FROM 持有数;GROUP BY 姓名 HAVING COUNT(*)>=4;ORDER BY 外币种类 AND 姓名 DESC
D. SELECT 姓名,COUNT(*)AS 外币种类 FROM 持有数;GROUP BY 姓名 HAVING COUNT(*)>=4;ORDER BY 外币种类+姓名 DESC