你是某销售组织的数据库开发人员, 你的数据库有一个名为Sales表, 此表包括了来自
10 查阅
SELECT TOP 20 PERCENT LastName, FirstName, SUM (OrderAmount) AS ytdFROM salesGROUP BY LastName, FirstNameORDER BY 3 DESC
SELECT LastName, FirstName, COUNT(*) AS salesFROM salesGROUP BY LastName, FirstNameHAVING COUNT (*) > 20ORDER BY 3 DESC
SELECT TOP 20 LastName, FirstName, MAX(OrderAmount) AS ytdFROM salesGROUP BY LastName, FirstNameORDER BY 3 DESC
SELECT TOP 20 LastName, FirstName, SUM (OrderAmount) AS ytdFROM salesGROUP BY LastName, FirstNameORDER BY 3 DESC
参考答案: