GROUP BY clause in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the GROUP BY clause do in SQL?

It groups rows that have the same values in specified columns into summary rows, like grouping all sales by each product.

beginner

Which SQL keyword is used to group rows that share the same value in one or more columns?

GROUP BY is used to group rows with the same values in specified columns.

beginner

Why do we often use aggregate functions like SUM() or COUNT() with GROUP BY?

Because GROUP BY creates groups of rows, aggregate functions calculate a summary value (like total or count) for each group.

intermediate

What happens if you use GROUP BY without an aggregate function?

The query will group rows but return one row per group without summarizing data, which might not be useful or can cause errors depending on the SQL mode.

intermediate

Can you use multiple columns in a GROUP BY clause? If yes, what does it do?

Yes, you can group by multiple columns. It groups rows that have the same combination of values in all those columns.

What is the main purpose of the GROUP BY clause in SQL?

A To sort rows in ascending order

B To combine rows with the same values into groups

C To delete duplicate rows

D To filter rows based on a condition

The GROUP BY clause groups rows that share the same values in specified columns.

Which of the following is an aggregate function often used with GROUP BY?

A ORDER BY

B WHERE

C JOIN

D SUM()

SUM() calculates the total of values in each group.

If you want to group sales data by both region and month, how would you write the GROUP BY clause?

A GROUP BY region, month

B GROUP BY region OR month

C GROUP BY region AND month

D GROUP BY region; GROUP BY month

Use commas to list multiple columns in GROUP BY.

What will happen if you use GROUP BY but select columns not in the group or aggregate functions?

A SQL will return an error or unpredictable results

B SQL will ignore the extra columns

C SQL will group by those columns automatically

D SQL will delete those columns

Selecting columns not in GROUP BY or aggregate functions can cause errors or unexpected results.

Which clause is usually paired with GROUP BY to filter groups after grouping?

A LIMIT

B WHERE

C HAVING

D ORDER BY

HAVING filters groups after GROUP BY is applied.

Explain how the GROUP BY clause works and why it is useful.

Think about how you might group sales by product to find totals.

Describe the difference between WHERE and HAVING clauses in relation to GROUP BY.

Consider when the filtering happens in the query process.