📘COUNT and SUM: do the math

Aggregate functions summarize rows: COUNT(*) counts, SUM(column) adds up. With GROUP BY, the math is done per group.

On a social network, the posts table has an author and likes. GROUP BY author gives one row per person.

SELECT author, COUNT(*) FROM posts GROUP BY author;