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

5 votes226 views2 answers
How to ascending order in sql
SQL
1 vote169 views1 answer
Local sql server
SQL
0 vote173 views1 answer
C# execute transact sql
SQL
0 vote129 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote166 views1 answer
Mysql master slave setup with keepalived
SQL
1 vote182 views1 answer
Flask sqlalchemy default value
SQL
-2 votes172 views3 answers
Sqlite reset autoincrement
SQL
0 vote187 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote158 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote176 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL