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 vote324 views1 answer
Mysql foreach insert
SQL
0 vote318 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote325 views1 answer
Mysql select field if condition
SQL
6 votes342 views2 answers
Insert into select mysql
SQL
0 vote331 views1 answer
Select all columns except one sql
SQL
0 vote344 views1 answer
Shortcut run sql pgadmin
SQL
0 vote321 views1 answer
Postgress append string in select
SQL
0 vote308 views1 answer
Remove from table where
SQL
0 vote316 views1 answer
Jooq replace
SQL
3 votes358 views1 answer
Sql set null
SQL