Summarizing query results using aggregate functions
The GROUP BY clause: organizing query results into groups
Understanding GROUP BY
The HAVING clause: selecting groups of data
The ORDER BY clause: sorting query results
Performing set operations on query results with UNION, INTERSECT, and EXCEPT
Standards and compatibility