Q&A for scientific skepticism
Select PostTypes.Name, Count(*) from Posttypes, posts where posttypes.id = posts.posttypeid group by name