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 vote115 views2 answers
Identity column in sql server
SQL
0 vote103 views1 answer
Where case insensitive like mysql
SQL
1 vote107 views1 answer
Sql how to duplicate a table
SQL
4 votes134 views2 answers
Dbms output
SQL
1 vote198 views2 answers
Postgres select from last 3 months
SQL
1 vote107 views1 answer
Woocommerce mysql price table
SQL
0 vote125 views1 answer
Oracle change password expiration policy
SQL
0 vote111 views1 answer
Postgres declare variable
SQL
0 vote109 views2 answers
Default constraint in ms sql
SQL
1 vote146 views1 answer
Select last row from SQL Table
SQL