easySQLINNER JOINSingle-choice MCQ

Tables: `categories` has 4 rows; `products` has 10 rows, each with a category_id that exists in categories. What does this query return?

SELECT c.name, COUNT(*) FROM categories c INNER JOIN products p ON p.category_id = c.id GROUP BY c.name;