JobPrax
SQL Aggregates & GROUP BY — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
Aggregates & GROUP BY
COUNT, SUM, AVG, MIN, MAX — overall and per group.
Your progress
0
/ 40
Start the first question
All levels
Basic (27)
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
How many employees?
Basic
9
Salary bill
Basic
10
Average price
Basic
11
Top score
Basic
12
Count electronics
Basic
13
Customers per city
Basic
14
Staff per department
Basic
15
Stock per category
Basic
16
Top salary per department
Basic
17
Orders per status
Basic
18
Revenue per region
Basic
19
Average per exam
Basic
20
Fees collected
Basic
21
Customers per state
Basic
22
First and last order
Basic
23
Transactions per account
Basic
24
Units sold per product
Basic
25
Students per class
Basic
26
Budget per department
Basic
27
Cheapest per category
Basic
28
Group by two columns
Intermediate
29
Revenue per order
Intermediate
30
Orders per payment method
Intermediate
31
Distinct count per group
Intermediate
32
Category summary
Intermediate
33
Hires per year
Intermediate
34
Conditional counting
Intermediate
35
Average score per subject
Intermediate
36
Share of total
Advanced
37
Revenue by category
Interview
Advanced
38
Average order value
Interview
Advanced
39
Median salary
Advanced
40
Gender pay gap per department
Advanced