DataDesk
All topics
Joins — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
Joins
INNER, LEFT, RIGHT and FULL joins across tables.
0
/ 20 solved
All levels
Basic (7)
Intermediate (8)
Advanced (5)
All
To do
Solved
1
Inner join
Basic
2
Left join keeps everyone
Basic
3
Orders with customer names
Basic
4
Table aliases
Basic
5
Join and filter
Basic
6
Departments without staff
Interview
Basic
7
Products never ordered
Interview
Basic
8
Three-table join
Intermediate
9
Join then aggregate
Intermediate
10
Customer spend
Intermediate
11
Customers who never ordered
Intermediate
12
Condition in ON vs WHERE
Intermediate
13
Full outer join
Intermediate
14
Join with USING
Intermediate
15
Items with product details
Intermediate
16
Sold below list price
Interview
Advanced
17
Department budget per head
Advanced
18
Customers who bought both
Interview
Advanced
19
Employees on no project
Advanced
20
Cross-department work
Advanced