JobPrax
SQL Self & cross joins — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
Self & cross joins
Join a table to itself and build combinations.
Your progress
0
/ 40
Start the first question
All levels
Basic (25)
Intermediate (8)
Advanced (7)
All
To do
Solved
1
Employee and manager
Interview
Basic
2
Include the top boss
Basic
3
All combinations
Basic
4
Count the combinations
Basic
5
Same city colleagues
Basic
6
Manager's job title
Basic
7
Rahul's team
Basic
8
Vikram's team
Basic
9
Who are the managers?
Basic
10
Manager's city
Basic
11
Finance pairs
Basic
12
Sizes and colours
Basic
13
Timetable grid
Basic
14
Count the pairs
Basic
15
Referred by Kabir
Basic
16
Neighbours
Basic
17
Same salary
Basic
18
Classmates from one city
Basic
19
Electronics × payment methods
Basic
20
Living away from the boss
Basic
21
Salary next to the manager's
Basic
22
Pricier than the desk lamp
Basic
23
Hired in Arjun's year
Basic
24
Times table
Basic
25
Same city as the manager
Basic
26
Earns more than the manager
Interview
Intermediate
27
Direct report count
Intermediate
28
Joined before the manager
Intermediate
29
Referral pairs
Intermediate
30
Top referrers
Intermediate
31
Matchday fixtures
Intermediate
32
Calendar of logins
Intermediate
33
Salary differences
Intermediate
34
Skip-level manager
Interview
Advanced
35
Consecutive-day logins
Interview
Advanced
36
Price gaps between products
Advanced
37
Team size per manager tree
Advanced
38
Cumulative total without windows
Advanced
39
Students who beat their classmate
Advanced
40
Missing assignments
Advanced