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; ORDERBY外币种类AND姓名DESC D.SELECT姓名,COUNT(*)AS外币种类FROM持有数; GROUP BY姓名HAVING COUNT(*)>=4; ORDER BY外币种类+姓名DESC