Common table expressions
WITH clauses for readability, reuse within a query, and stepwise construction of a complex result.
Decompose a complex query into named CTEs that each answer one clear question
Up to 1 question on this skill alone, marked against the bar beside this. It stops as soon as the answer is clear. No account, and your answers are not kept.
You'll need these first
What it unlocks
Start on SQL & Data Analysis
Every skill above, ordered by what depends on what, with the projects above that as the evidence you actually did it. We work out where you already are first, so the path skips what you can do.
Start this path