Q&A for Ubuntu users and developers
select top 100 posttypeid, count(*) from posts where creationdate > '2012' group by posttypeid order by count(*) desc