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 vote132 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
2 votes102 views5 answers
Alter table primary key postgresql
SQL
0 vote150 views1 answer
Mysql limit order by
SQL
-1 vote134 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote140 views1 answer
Suse status MySQL
SQL
0 vote455 views1 answer
How to connect .sql data set to powerbi
SQL
6 votes145 views2 answers
Psql load dump
SQL
0 vote137 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote145 views1 answer
Oracle select partition
SQL
0 vote155 views1 answer
Mysql min value row
SQL