Listing 3: GROUP BY clause with aggregate function 
SELECT Salesperson, SalesRank, Count(*) SalesCount 
FROM Sales 
GROUP BY Salesperson, SalesRank