JobPrax
SQL CTEs (WITH) — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
CTEs (WITH)
Break problems into readable steps.
Your progress
0
/ 40
Start the first question
All levels
Basic (25)
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
Name a filtered list
Basic
7
Average in a CTE
Basic
8
Count delivered orders
Basic
9
Big orders
Basic
10
Large teams
Basic
11
Cheapest gadget
Basic
12
Stock by category, sorted
Basic
13
Good students
Basic
14
Cities with two customers
Basic
15
Credits per account
Basic
16
Names of fee defaulters
Basic
17
Top region
Basic
18
New joiners per department
Basic
19
Spend with names
Basic
20
Big projects and owners
Basic
21
Two CTEs: in and out
Basic
22
Regular users
Basic
23
North average
Basic
24
How many cities?
Basic
25
Most valuable stock
Basic
26
Customer tiers
Intermediate
27
Tier counts
Intermediate
28
Category share
Intermediate
29
First order per customer
Intermediate
30
Signup to first order
Intermediate
31
Department summary
Intermediate
32
Generate a number series
Intermediate
33
Org chart levels
Interview
Advanced
34
Everyone under a manager
Advanced
35
Fill missing months
Interview
Advanced
36
Repeat purchase rate
Interview
Advanced
37
Funnel of order statuses
Advanced
38
Best month per category
Advanced
39
Factorial with recursion
Advanced
40
Cohort retention
Interview
Advanced