DataDesk
All topics
HAVING — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
HAVING
Filter groups after aggregating.
0
/ 20 solved
All levels
Basic (6)
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
WHERE and HAVING together
Intermediate
8
Categories with low stock
Intermediate
9
Customers who only use UPI
Intermediate
10
Students who failed a subject
Intermediate
11
Spread of salaries
Intermediate
12
Accounts with net outflow
Intermediate
13
Popular products
Intermediate
14
Above the company average
Interview
Advanced
15
Customers who bought from 3 categories
Advanced
16
Strong classes
Advanced
17
Months with growth in every region
Advanced
18
Duplicate emails, case-insensitive
Interview
Advanced
19
Managers with big teams
Advanced
20
Projects over-allocated
Advanced