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