Unit 1: Reading data: SELECT, WHERE and sorting

Pick the columns you want, keep only the rows you want, sort them, and handle the missing values that trip everyone up.

The big picture

Most queries you will ever write are a SELECT with a WHERE and an ORDER BY. Get these, plus NULL, completely solid, and the rest of SQL is built on top of them.

Lessons in this unit