GROUP BY
GROUP BY collapses rows that share the same value into a single group, so you can run an aggregate (like COUNT or SUM) on each group separately.
GROUP BY collapses rows that share the same value into a single group, so you can run an aggregate (like COUNT or SUM) on each group separately.