Multi-Column Group By — Solution & ExplanationProblems / Multi-Column Group By / EditorialApproach

GROUP BY region, product_category to create a group for every unique (region, category) pair.

SUM(amount) within each group.

ORDER BY both columns for a stable, readable result.

Key ConceptWhen you GROUP BY multiple columns, the result has one row per unique combination of those column values. This is how you build cross-tabulation / pivot-style reports in SQL.Hints

GROUP BY accepts multiple columns separated by commas.

Each unique combination of (region, product_category) becomes its own group.

Solve Multi-Column Group By yourself →