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

1 vote133 views1 answer
Mysql show table character set
SQL
0 vote138 views1 answer
T sql less than date
SQL
0 vote147 views2 answers
SQL FROM
SQL
2 votes181 views1 answer
Sql compare strings
SQL
13 votes150 views5 answers
Sql default
SQL
2 votes133 views1 answer
Sql update from different table
SQL
1 vote149 views1 answer
Mysql workbench in ubuntu 14.04
SQL
1 vote146 views1 answer
Psql import backup file for windows
SQL
3 votes150 views1 answer
Oracle undo tablespace schema
SQL
2 votes150 views1 answer
How to get non distinct values in sql
SQL