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:
01 SELECT *
02 FROM (SELECT Customer.CustomerID, SUM(TotalDue) AS TotalGiven,
3
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?
A. NTILE(100) OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
B. DENSE_RANK() OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
C. ROW_NUMBER() OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
D. RANK() OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
