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