How many edits of each type did I make?
Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language
-- Number of edits
-- How many edits of each type did I make?
SELECT T.Name, Count(*)
FROM PostHistory H
INNER JOIN PostHistoryTypes T ON H.PostHistoryTypeId = T.Id
WHERE H.UserId = ##user##
GROUP BY T.Name