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

5 votes232 views1 answer
Purge undo tablespace usage
SQL
1 vote189 views1 answer
Full text index mysql
SQL
3 votes208 views1 answer
Mysql UPDate with enner join
SQL
0 vote220 views1 answer
Mysql concat and use as where column
SQL
0 vote238 views1 answer
Will graphql replace sql
SQL
3 votes222 views2 answers
Pl sql escape '
SQL
3 votes250 views1 answer
Create a table with an id in mysql
SQL
1 vote237 views2 answers
Sql server concat string and int
SQL
9 votes214 views3 answers
Mysql get last id
SQL
2 votes222 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL