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 vote247 views1 answer
TSQL Find csv file in folder
SQL
0 vote205 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote234 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote273 views1 answer
Linux upload database to mysql
SQL
0 vote187 views1 answer
Mysql command prompt date insert format
SQL
3 votes194 views1 answer
Sql double index
SQL
0 vote184 views1 answer
Typeorm raw sql
SQL
1 vote197 views2 answers
Drop table if exists test
SQL
11 votes175 views1 answer
Mysql order by two columns priority
SQL
0 vote171 views1 answer
View acl table oracle
SQL