DataDesk
All topics
Subqueries — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
Subqueries
Queries inside queries: IN, EXISTS and scalar subqueries.
0
/ 20 solved
All levels
Basic (6)
Intermediate (7)
Advanced (7)
All
To do
Solved
1
Above the average
Interview
Basic
2
The highest earner
Basic
3
IN with a subquery
Basic
4
Customers who ordered
Basic
5
NOT IN
Basic
6
Scalar subquery in SELECT
Basic
7
Above their department average
Interview
Intermediate
8
EXISTS
Intermediate
9
NOT EXISTS
Intermediate
10
Subquery in FROM
Intermediate
11
Latest order per customer
Intermediate
12
Most expensive in category
Intermediate
13
ALL and ANY
Intermediate
14
Nth highest salary
Interview
Advanced
15
Customers above average spend
Advanced
16
Departments with every role
Advanced
17
Products bought by top customer
Advanced
18
Second most recent login
Advanced
19
Projects bigger than department average
Advanced
20
Students above class average in Maths
Advanced