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

33 votes169 views6 answers
Sql delete
SQL
8 votes168 views2 answers
Replace string value in sql
SQL
0 vote187 views1 answer
Difference between db.query and db.execute
SQL
0 vote186 views1 answer
Combine 2 columns search query mysql
SQL
0 vote265 views1 answer
Database timezone
SQL
-1 vote246 views1 answer
Minus vs except in sql
SQL
0 vote273 views1 answer
Sqlite woth cmake
SQL
4 votes161 views1 answer
Id primary key auto generated
SQL
0 vote175 views1 answer
Postgresql isnull with max
SQL
1 vote294 views2 answers
Postgres select from last 3 months
SQL