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)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

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
FROM   users;

Enter Parameters

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