Count rows per group

GROUP BY with COUNT(*) gives one row per group.

More SQL recipes

• Find duplicate values
• Get the top N rows per query
• Find rows with no match in another table
• Calculate a running total
• Pivot values into columns with CASE