Q&A about the site for Drupal developers and administrators
select top 100 posttypeid, count(*) from posts where creationdate > '2012' group by posttypeid order by count(*) desc