Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
-- Enter Query Title -- Enter Query Description select sum(case when ViewCount > 100000 then 1 end) as PopPosts, sum(case when ViewCount <= 100000 and ViewCount > 50000 then 1 end) as HugePosts, sum(case when ViewCount <= 50000 and ViewCount > 10000 then 1 end) as LargePosts, sum(case when ViewCount <= 10000 and ViewCount > 5000 then 1 end) as MedPosts, sum(case when ViewCount <= 5000 and ViewCount > 2500 then 1 end) as RegPosts, sum(case when ViewCount <= 2500 and ViewCount > 1000 then 1 end) as SmallPosts, sum(case when ViewCount <= 1000 and ViewCount > 100 then 1 end) as MiniPosts, sum(case when ViewCount <= 100 then 1 end) as TinyPosts FROM Posts p WHERE p.ParentId is null