DataDesk
SQL Joins — practice questions · DataDesk
DataDesk
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
Joins
INNER, LEFT, RIGHT and FULL joins across tables.
Your progress
0
/ 40
Start the first question
All levels
Basic (27)
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
Employee and department
Basic
9
Projects and departments
Basic
10
Who placed the order?
Basic
11
What was in each order?
Basic
12
Subject names
Basic
13
Fees with names
Basic
14
Where do they work?
Basic
15
Every department, staff or not
Basic
16
Orders from Delhi
Basic
17
Mumbai offices
Basic
18
Inside order 1001
Basic
19
Team on project 101
Basic
20
Priya's projects
Basic
21
Head count by name
Basic
22
Delivered orders
Basic
23
UPI orders by city
Basic
24
Maths final marks
Basic
25
Unpaid fees
Basic
26
Every customer and their orders
Basic
27
Line totals
Basic
28
Three-table join
Intermediate
29
Join then aggregate
Intermediate
30
Customer spend
Intermediate
31
Customers who never ordered
Intermediate
32
Condition in ON vs WHERE
Intermediate
33
Full outer join
Intermediate
34
Join with USING
Intermediate
35
Items with product details
Intermediate
36
Sold below list price
Interview
Advanced
37
Department budget per head
Advanced
38
Customers who bought both
Interview
Advanced
39
Employees on no project
Advanced
40
Cross-department work
Advanced