Q&A for linguists, etymologists, and serious English language enthusiasts
select pt.name, count(*) from posts p join posttypes pt on p.posttypeid = pt.id group by pt.name