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 vote157 views1 answer
Select odd records sql
SQL
1 vote165 views2 answers
Mysql extract number from string
SQL
0 vote140 views1 answer
Como saber si tengo mysql instalado
SQL
-1 vote196 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote160 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote170 views1 answer
How much space does sql server take per row
SQL
5 votes159 views1 answer
Mysql where one year ago
SQL
1 vote172 views1 answer
Mysql current running queries
SQL
0 vote139 views1 answer
Heavy table in mysql
SQL
0 vote150 views1 answer
Query by column for substring sql
SQL