Q&A for active researchers, academics and students of physics
Select PostTypes.Name, Count(*) AS [Count of Posts] from Posttypes, posts where posttypes.id = posts.posttypeid group by name