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 vote251 views1 answer
Check command
SQL
1 vote234 views1 answer
Sql server locks
SQL
1 vote237 views1 answer
Mysql stop password policy
SQL
3 votes222 views2 answers
Having in mysql
SQL
0 vote238 views1 answer
Psql datestyle
SQL
1 vote238 views1 answer
Best sql course
SQL
6 votes272 views2 answers
Subtr Oracle ?
SQL
0 vote241 views1 answer
Add multiple field in table sql
SQL
0 vote236 views1 answer
Start and stop mysql
SQL
3 votes230 views1 answer
How to uninstall microsoft sql server
SQL