Summarizing, grouping, and sorting query results


Aggregate functions that summarize query results
The GROUP BY clause: Organizing query results into groups
The HAVING clause: Selecting groups of data
The ORDER BY clause: Sorting query results
Set operations on query results using UNION, INTERSECT, and EXCEPT