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

3 votes353 views2 answers
To_char oracle
SQL
5 votes335 views4 answers
Describe table postgres
SQL
0 vote351 views1 answer
Add unique constraint sql server multiple columns
SQL
1 vote363 views1 answer
Check current sequence value postgres
SQL
0 vote347 views1 answer
Install package for sqlserver in asp.net core
SQL
-1 vote380 views1 answer
Create view in mysql workbench
SQL
0 vote337 views1 answer
Sql get table last modified time
SQL
0 vote343 views2 answers
Sql use not in
SQL
2 votes356 views1 answer
How to make multiple keys as primary in bdms
SQL
6 votes378 views2 answers
Mysql execute file
SQL