Cellwise · SQL track

Grouping with GROUP BY

A summary for each group, like a PivotTable.

GROUP BY splits rows into groups and summarizes each one, much like a PivotTable.

WHERE filters rows before grouping. HAVING filters the groups afterward, which is how you keep groups above a certain total.

What you’ll do

• Count by group
• Total by group, sorted
• Filter the groups