Quiz for GROUP BY Clause

Q1: Which clause is used to group rows sharing a property?

A. ORDER BY B. HAVING C. GROUP BY D. PARTITION BY

Q2: What is the purpose of the GROUP BY clause in SQL?

A. Sorts records alphabetically B. Limits the number of results C. Filters individual rows D. Groups rows sharing a common value