DataDesk
All topics
CTEs (WITH) — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
CTEs (WITH)
Break problems into readable steps.
0
/ 20 solved
All levels
Basic (5)
Intermediate (7)
Advanced (8)
All
To do
Solved
1
Your first CTE
Basic
2
Order totals
Basic
3
CTE for a filter value
Basic
4
Two CTEs
Basic
5
Readable monthly report
Basic
6
Customer tiers
Intermediate
7
Tier counts
Intermediate
8
Category share
Intermediate
9
First order per customer
Intermediate
10
Signup to first order
Intermediate
11
Department summary
Intermediate
12
Generate a number series
Intermediate
13
Org chart levels
Interview
Advanced
14
Everyone under a manager
Advanced
15
Fill missing months
Interview
Advanced
16
Repeat purchase rate
Interview
Advanced
17
Funnel of order statuses
Advanced
18
Best month per category
Advanced
19
Factorial with recursion
Advanced
20
Cohort retention
Interview
Advanced