select dist_views, count(*) as user_count from ( select c...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

select dist_views, count(*) as user_count
from
(
 select case when Views between 0  and 10 then '(0, 10)'
             when Views between 10 and 50 then '(10, 50)'
             when Views between 50 and 100 then '(50, 100)'
             when Views between 100 and 500 then '(100, 500)'
             when Views between 500 and 1000 then '(500, 1000)'
             when Views between 1000 and 5000 then '(1000, 5000)'
             when Views between 5000 and 10000 then '(5000, 10000)'
             when Views between 10000 and 100000 then '(10000, 100000)' end as dist_views
 from Users
) a
group by dist_views;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results