Q&A for professional and enthusiast programmers
SELECT t.Name, COUNT(PostId) Kount FROM PostHistory ph INNER JOIN PostHistoryTypes t ON ph.PostHistoryTypeID = t.id GROUP BY t.Name