假设 Sales 表用于存储销售信息, sal_name 列为销售人员姓名, sal_money 列为销售额度,现在要查询每个销售人员的销售次数、销售总金额,则下面的哪条语句可以实现这些功能( )。
A.
SELECT sal_name,SUM(sal_money),COUNT(sal_name) FROM Sales GROUP BY sal_name
B.
SELECT sal_name,SUM(sal_money),COUNT(sal_name) FROM Sales ORDER BY sal_name
C.
SELECT sal_name,AVG(sal_money),COUNT(sal_name) FROM Sales
D.
SELECT sal_name,SUM(sal_money) FROM Sales GROUP BY sal_name ORDER BY sal_name