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)

Christianity Meta

Q&A about the site for committed Christians, experts in Christianity and those interested in learning more

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 20000 then '(5000, 20000)' end as dist_views
 from Users
) a
group by dist_views;

Enter Parameters

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