Part 1 – SELECT statement basics
Part 2 – SELECT with AND, OR, NOT, LIKE, ISNULL, and Wildcards
Part 3 – SELECT with COUNT, MIN/MAX, Order By, Subqueries
Part 4 – Multi-table JOINs