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 vote204 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote232 views1 answer
Postgresql alter table sequence
SQL
0 vote227 views1 answer
Sql query to select even numbers
SQL
2 votes187 views4 answers
Check timezone of mysql database
SQL
38 votes265 views4 answers
Count sql
SQL
0 vote178 views1 answer
Postgresql alter column nullable
SQL
0 vote145 views1 answer
Delete all rows from table sqlite
SQL
0 vote175 views1 answer
Postgresql find missing id
SQL
-1 vote161 views1 answer
Mysql if example
SQL
0 vote187 views1 answer
Create database store
SQL