GROUP BY
6 practice questionsDatabase SystemsStep-by-step solutions
Try a few
1
Which SQL aggregate function returns the number of rows?
A.SUM()
B.COUNT()
C.AVG()
D.MAX()
2
GROUP BY is typically used together with:
A.Aggregate functions
B.Foreign keys
C.Indexes
D.Triggers
3
To filter groups produced by GROUP BY, you use:
A.WHERE
B.HAVING
C.ORDER BY
D.LIMIT
Master group by — not just preview it
All 6 questions with worked solutions, an AI tutor that explains every step, and games that make the drilling stick. Free to start.
Practice this topic freeNo card needed · 10 free AI questions daily