Recall
Set 1: Quick Check
Use a CTE as a named step and place its clauses in written order.
CTEs and Introductory Window Functions
Build stepwise queries and add group-aware context without collapsing detail rows.
Start Chapter PracticeChapter plan
What you will be able to do
- Use WITH and introductory ROW_NUMBER window logic.
- Study time
- 32–38 minutes, self-paced
- Course
- SQL for Data Analysis (Beginner)
- Practice order
- Four sets, completed in sequence
Chapter practice
Practice in chapter order
10 activities · 80% mastery target
Start set 1
Guided application
Set 2: Core Practice
Distinguish grouped from window results and reason about partitions and stable ranks.
Hands-on
Set 3: Workplace Task
Build a shipped-order CTE and rank orders within status groups.
Independent check
Set 4: Mastery Check
Predict a row number and independently add customer totals without collapsing detail.