JobPrax
SQL HAVING — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
HAVING
Filter groups after aggregating.
Your progress
0
/ 40
Start the first question
All levels
Basic (26)
Intermediate (7)
Advanced (7)
All
To do
Solved
1
Cities with many staff
Basic
2
Departments with a high average
Basic
3
Repeat customers
Basic
4
Busy projects
Basic
5
Big spenders
Basic
6
Duplicate logins
Basic
7
Cities with repeat customers
Basic
8
Big departments
Basic
9
Busy categories
Basic
10
Frequent buyers
Basic
11
Shared job titles
Basic
12
States with 2+ customers
Basic
13
Costly departments
Basic
14
Premium categories
Basic
15
Popular payment methods
Basic
16
Big earners in credits
Basic
17
Cities with many students
Basic
18
Products in many orders
Basic
19
Regular users
Basic
20
Strong regions
Basic
21
Well-paid departments
Basic
22
Students averaging above 70
Basic
23
Crowded projects
Basic
24
Orders with several items
Basic
25
Cities with one employee
Basic
26
Low-stock categories
Basic
27
WHERE and HAVING together
Intermediate
28
Categories with low stock
Intermediate
29
Customers who only use UPI
Intermediate
30
Students who failed a subject
Intermediate
31
Spread of salaries
Intermediate
32
Accounts with net outflow
Intermediate
33
Popular products
Intermediate
34
Above the company average
Interview
Advanced
35
Customers who bought from 3 categories
Advanced
36
Strong classes
Advanced
37
Months with growth in every region
Advanced
38
Duplicate emails, case-insensitive
Interview
Advanced
39
Managers with big teams
Advanced
40
Projects over-allocated
Advanced