DataDesk
All topics
Aggregates & GROUP BY — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
Aggregates & GROUP BY
COUNT, SUM, AVG, MIN, MAX — overall and per group.
0
/ 20 solved
All levels
Basic (7)
Intermediate (8)
Advanced (5)
All
To do
Solved
1
Count rows
Basic
2
Sum and average
Basic
3
Minimum and maximum
Basic
4
Count with a filter
Basic
5
Group by one column
Basic
6
Average per group
Basic
7
COUNT(column) vs COUNT(*)
Basic
8
Group by two columns
Intermediate
9
Revenue per order
Intermediate
10
Orders per payment method
Intermediate
11
Distinct count per group
Intermediate
12
Category summary
Intermediate
13
Hires per year
Intermediate
14
Conditional counting
Intermediate
15
Average score per subject
Intermediate
16
Share of total
Advanced
17
Revenue by category
Interview
Advanced
18
Average order value
Interview
Advanced
19
Median salary
Advanced
20
Gender pay gap per department
Advanced