PrepAway - Latest Free Exam Questions & Answers

Tag: you work for an international charity organization you are writing a query to list the highest 100 different amounts that were donated you have written the following code segment (line numbers are inc

Which Transact-SQL clause should you insert?

You work for an international charity organization. You are writing a query to list the highest 100 different amounts that were donated. You have written the following code segment (Line numbers are included for reference only):

01 SELECT *
02 FROM (SELECT Customer.CustomerID, SUM(TotalDue) AS TotalGiven,
03 ………………..
04 FROM Customer
05 JOIN SalesOrder
06 ON Customer.CustomerID = SalesOrder.CustomerID
07 GROUP BY Customer.CustomerID) AS DonationsToFilter
08 WHERE FilterCriteria <= 100

You need to insert a Transact-SQL clause in line 03 to complete the query. Which Transact-SQL clause should you insert?