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 vote280 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
1 vote265 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote286 views1 answer
Sql ssrs
SQL
0 vote224 views1 answer
'0000-00-00' for column '
SQL
16 votes338 views2 answers
Sql vs nosql
SQL
2 votes292 views1 answer
Sql find not in list
SQL
0 vote279 views1 answer
Mysql update from select on same table
SQL
31 votes256 views1 answer
Postgresql add column with constraint
SQL
0 vote252 views1 answer
Login failed for login due to trigger execution
SQL
0 vote280 views3 answers
CONTACT FORM SQL
SQL