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

9 votes182 views1 answer
Mysql check date range
SQL
3 votes207 views5 answers
Sql select
SQL
0 vote200 views1 answer
The fetch keyword oracle
SQL
36 votes192 views6 answers
Delete from where sql
SQL
21 votes195 views6 answers
Change column in mysql
SQL
0 vote175 views2 answers
Sql if empty then
SQL
0 vote213 views2 answers
Greater than sql server
SQL
0 vote184 views1 answer
Linked server delete openquery
SQL
0 vote174 views1 answer
How to check if there is no database schema
SQL
0 vote172 views1 answer
Can we rollback data that are deleted using DELETE
SQL