Compute the best 10 SalesReps based on total sales from the first quarter of this year:

RETURN BestReps AS
SELECT SUM(Amount) AS Total
WHERE Quarter = '09Q1'
GROUP BY SalesRep
ORDER BY Total DESC
PAGE(0,10)


Copyright © Legal Notices