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 vote150 views1 answer
Mysql could not fetch tables
SQL
1 vote209 views1 answer
Mysql breakline on string
SQL
2 votes124 views1 answer
Mysql set value as null
SQL
0 vote153 views1 answer
Postgres select from values
SQL
1 vote135 views1 answer
Sql first day quarter
SQL
0 vote119 views1 answer
Java spring boot connect to sql server
SQL
0 vote114 views1 answer
Oracle DROP PROGRAM
SQL
0 vote123 views1 answer
Components/Fields of Internal Table
SQL
5 votes118 views2 answers
Oracle timestamp to date
SQL
0 vote133 views1 answer
What is database username and password in mysqliconnect
SQL