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 vote263 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote244 views1 answer
We are intrested to work with your organization
SQL
60 votes417 views6 answers
Add column in sql
SQL
5 votes243 views1 answer
Mysql change primary key
SQL
1 vote287 views1 answer
Sql how to replace full stop
SQL
0 vote244 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
3 votes225 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
14 votes271 views2 answers
Install mysqldump
SQL
1 vote261 views1 answer
Sql alchemy with azuresql server
SQL
0 vote235 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL