Query editor
WITH Leaderboard AS (SELECTclaimer,COUNT(*) as CUBES_claimedFROMquery_3434928GROUP BYclaimer),leaderboard_ranked AS (SELECTclaimer,CUBES_claimed,CASEWHEN CUBES_claimed BETWEEN 0 AND 25 THEN '0 - 25'WHEN CUBES_claimed BETWEEN 26 AND 50 THEN '25 - 50'WHEN CUBES_claimed BETWEEN 51 AND 75 THEN '50 - 75'WHEN CUBES_claimed BETWEEN 76 AND 99 THEN '75 - 99'WHEN CUBES_claimed BETWEEN 100 AND 124 THEN '100 - 124'WHEN CUBES_claimed BETWEEN 125 AND 149 THEN '125 - 149'WHEN CUBES_claimed BETWEEN 150 AND 174 THEN '150 - 174'WHEN CUBES_claimed BETWEEN 175 AND 199 THEN '175 - 199'WHEN CUBES_claimed BETWEEN 200 AND 224 THEN '200 - 224'WHEN CUBES_claimed BETWEEN 225 AND 249 THEN '225 - 249'WHEN CUBES_claimed BETWEEN 250 AND 274 THEN '250 - 274'WHEN CUBES_claimed BETWEEN 275 AND 299 THEN '275 - 299'WHEN CUBES_claimed BETWEEN 300 AND 324 THEN '300 - 324'WHEN CUBES_claimed BETWEEN 325 AND 349 THEN '324 - 349'WHEN CUBES_claimed BETWEEN 350 AND 374 THEN '350 - 374'WHEN CUBES_claimed BETWEEN 375 AND 499 THEN '375 - 500'WHEN CUBES_claimed BETWEEN 500 AND 598 THEN '501 - 599'WHEN CUBES_claimed >= 614 THEN '615+'END AS cube_rangeFROMLeaderboard)SELECTcube_range,COUNT(*) as number_of_playersFROMleaderboard_rankedGROUP BYcube_rangeORDER BYCASEWHEN cube_range = '375+' THEN 16WHEN cube_range = '350 - 374' THEN 15WHEN cube_range = '324 - 349' THEN 14WHEN cube_range = '300 - 324' THEN 13WHEN cube_range = '275 - 299' THEN 12WHEN cube_range = '250 - 274' THEN 11WHEN cube_range = '225 - 249' THEN 10WHEN cube_range = '200 - 224' THEN 9WHEN cube_range = '175 - 199' THEN 8WHEN cube_range = '150 - 174' THEN 7WHEN cube_range = '125 - 149' THEN 6WHEN cube_range = '100 - 114' THEN 5WHEN cube_range = '75 - 99' THEN 4WHEN cube_range = '50 - 75' THEN 3WHEN cube_range = '25 - 50' THEN 2