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

4 votes316 views3 answers
Sql drop database if exists
SQL
0 vote293 views2 answers
Sql join on comma separated field
SQL
0 vote300 views1 answer
Mysql shell ERROR: Not connected.
SQL
1 vote307 views2 answers
Postgres cast as decimal
SQL
10 votes318 views2 answers
What is database
SQL
8 votes285 views3 answers
Mysql alter table add index
SQL
1 vote305 views2 answers
Pad zero sql server
SQL
20 votes311 views3 answers
How to open postgresql in mac
SQL
7 votes273 views2 answers
Create index mysql
SQL
0 vote300 views2 answers
How to set global time_zone in mysql
SQL