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 vote215 views1 answer
Docker open terminal mysql server
SQL
0 vote213 views1 answer
Mysql query to add hours to column in table
SQL
12 votes255 views4 answers
How to drop all tables in postgresql
SQL
-1 vote206 views1 answer
Sql getdate date only
SQL
1 vote234 views2 answers
Sql server backup table
SQL
2 votes219 views1 answer
Copy all values of a column to another column in sql in same table
SQL
3 votes205 views1 answer
Oracle nextval
SQL
0 vote213 views1 answer
Set open file limit mac catalina mysql
SQL
8 votes246 views1 answer
Mysql dump restore
SQL
0 vote237 views2 answers
Compound operator in sql
SQL