Mysql group by range

select 
  case 
    when RESULT between 0 and 50 then '0-50'
    when RESULT between 50 and 100 then '51-100'
    when RESULT between 100 and 150 then '101-150'
    when RESULT between 150 and 200 then '151-200'
    when RESULT between 200 and 250 then '201-250'
    else 'OTHERS'
  end as `Range`,
  count(1) as `Count`
from PERSON
group by `Range`;

Source: dba.stackexchange.com

Similar codes

0 vote267 views1 answer
Drop a field in psql django
SQL
0 vote274 views1 answer
Oracle sql drop table
SQL
2 votes280 views1 answer
Update with join sql server
SQL
1 vote275 views1 answer
Sql server 2012 query history
SQL
-1 vote270 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
7 votes261 views1 answer
Sql management studio display line numbers
SQL
0 vote285 views1 answer
Oracle locked objects
SQL
1 vote239 views1 answer
Unique vs distinct sql
SQL
3 votes258 views3 answers
Mysql select table names
SQL
17 votes317 views2 answers
T_sql contains
SQL