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 vote208 views1 answer
Sql server system messeges
SQL
4 votes140 views2 answers
Mysql how to change default charset
SQL
0 vote105 views0 answer
SQL
0 vote175 views1 answer
Many rows to 1 string mysql
SQL
0 vote215 views1 answer
Order by number of character in sql
SQL
0 vote177 views1 answer
How to check foreign key constraint in sql
SQL
6 votes165 views2 answers
Insert into select mysql
SQL
0 vote152 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote153 views1 answer
Ksql quickstart docker
SQL
4 votes170 views3 answers
NOT NULL SQL
SQL