SELECT COUNT( CASE WHEN 0 <= Views AND Views <= 10 TH...

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 COUNT( CASE WHEN   0 <= Views AND Views <=   10 THEN Views END ) AS in_range_0_10,
       COUNT( CASE WHEN  10 <  Views AND Views <=   50 THEN Views END ) AS in_range_10_50,
       COUNT( CASE WHEN  50 <  Views AND Views <=  100 THEN Views END ) AS in_range_50_100,
       COUNT( CASE WHEN 100 <  Views AND Views <=  500 THEN Views END ) AS in_range_100_500,
       COUNT( CASE WHEN 500 <  Views AND Views <= 1000 THEN Views END ) AS in_range_500_1000,
       COUNT( CASE WHEN 1000 <  Views AND Views <= 5000 THEN Views END ) AS in_range_1000_5000,
       COUNT( CASE WHEN 5000 <  Views AND Views <= 20000 THEN Views END ) AS in_range_5000_20000
FROM   Users;

Enter Parameters

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