JobPrax
SQL UNION, INTERSECT & EXCEPT — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
UNION, INTERSECT & EXCEPT
Combine and compare result sets.
Your progress
0
/ 40
Start the first question
All levels
Basic (25)
Intermediate (7)
Advanced (8)
All
To do
Solved
1
UNION
Basic
2
UNION ALL
Basic
3
INTERSECT
Basic
4
EXCEPT
Basic
5
Cities from two tables
Basic
6
All cities, once each
Basic
7
Keep the repeats
Basic
8
Cities with both
Basic
9
Cities without an office
Basic
10
Cities with no engineers
Basic
11
Delhi customers who ordered
Basic
12
Never ordered
Basic
13
Electronics that sold
Basic
14
Unsold products
Basic
15
10A students who paid
Basic
16
Pune or Mumbai students
Basic
17
Either day
Basic
18
Both days
Basic
19
Came once, not again
Basic
20
HR at a glance
Basic
21
Roles only in Bengaluru
Basic
22
Delivered UPI orders
Basic
23
South Indian customers
Basic
24
Students to follow up
Basic
25
How many places?
Basic
26
Label the source
Intermediate
27
Cities with staff but no office
Intermediate
28
Combine different events
Intermediate
29
Total row with UNION
Intermediate
30
Customers who ordered and referred
Intermediate
31
Employees in Engineering but not on projects
Intermediate
32
Months with orders or signups
Intermediate
33
Symmetric difference
Interview
Advanced
34
Compare two table versions
Interview
Advanced
35
Multiset difference
Advanced
36
Revenue and cost in one report
Advanced
37
Customers active in both halves
Advanced
38
Unpivot with UNION ALL
Advanced
39
Top and bottom together
Advanced
40
Students missing a paper
Advanced