Mixing aggregate and non-aggregate columns

Question

Accepted Answer

When you mix aggregate functions with non-aggregate columns, every non-aggregate column must appear in GROUP BY. Here COUNT(*) returns one number for the whole table, but name has one value per row - the database can't collapse multiple names into one result row without knowing how to group them. Fix this with GROUP BY name (count per name) or remove name from the SELECT list (count all rows).