Group By

The GROUP BY clause is the next step after mastering ORDER BY. John Paul Ashenfelter shows you how to combine database records into a single record to calculate an aggregate function.