你是一个销售机构的数据库开发者,你的数据库有个表名为Sales,包含有关于从销售员的销售定单的汇总信息。销售管理人员要你创建一个有20个最高的销售的销售员的一个报表。哪个查询语句可以用来完成这项
A、SELECT TOP 20 PERCENT LastName, FirstName, SUM (OrderAmount) AS ytdFROM salesGROUP BY LastName, FirstNameORDER BY 3 DESC
B、SELECT LastName, FirstName, COUNT(*) AS salesFROM salesGROUP BY LastName, FirstNameHAVING COUNT (*) >20ORDER BY 3 DESC
C、SELECT TOP 20 WITH TIES LastName, FirstName, SUM (OrderAmount) AS ytdFROM salesGROUP BY LastName, FirstNameORDER BY 3 DESC
D、SELECT TOP 20 LastName, FirstName, SUM (OrderAmount) AS ytdFROM salesGROUP BY LastName, FirstNameORDER BY 3 DESC