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 vote342 views1 answer
Postgres jsonb array push new element
SQL
2 votes355 views1 answer
Mysql now format
SQL
1 vote384 views1 answer
Mysql login console
SQL
0 vote339 views1 answer
Postgres where
SQL
0 vote345 views2 answers
How to know the character set of an oracle databes
SQL
0 vote370 views1 answer
Sql sum if
SQL
2 votes290 views1 answer
Sql group by different columns
SQL
0 vote369 views1 answer
Insert data from stored procedure into table
SQL
1 vote403 views1 answer
Import sql file from laravel
SQL
15 votes343 views3 answers
Create table with primary key auto increment in sql
SQL