Q&A for historians and history buffs
SELECT u.Id, COUNT(p.Id) FROM Users u LEFT JOIN Posts p ON u.Id = p.OwnerUserId GROUP BY u.Id;