JobPrax
SQL Subqueries — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
Subqueries
Queries inside queries: IN, EXISTS and scalar subqueries.
Your progress
0
/ 40
Start the first question
All levels
Basic (26)
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 the average price
Basic
8
Below the average salary
Basic
9
The cheapest product
Basic
10
The newest employee
Basic
11
Staff in Mumbai departments
Basic
12
COD customers
Basic
13
Never sold
Basic
14
Kavya's department
Basic
15
Fee not paid
Basic
16
The biggest project
Basic
17
How many above average?
Basic
18
Distance from the average
Basic
19
Orders from Gujarat
Basic
20
Bengaluru projects
Basic
21
People who manage someone
Basic
22
No project at all
Basic
23
Bigger than usual
Basic
24
Latest signup
Basic
25
Kunal's classmates
Basic
26
Pricier than average fashion
Basic
27
Above their department average
Interview
Intermediate
28
EXISTS
Intermediate
29
NOT EXISTS
Intermediate
30
Subquery in FROM
Intermediate
31
Latest order per customer
Intermediate
32
Most expensive in category
Intermediate
33
ALL and ANY
Intermediate
34
Nth highest salary
Interview
Advanced
35
Customers above average spend
Advanced
36
Departments with every role
Advanced
37
Products bought by top customer
Advanced
38
Second most recent login
Advanced
39
Projects bigger than department average
Advanced
40
Students above class average in Maths
Advanced