0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created jan 3 11 anonymous