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

3 votes206 views3 answers
C# sql select
SQL
6 votes190 views1 answer
Rank function in oracle with example
SQL
0 vote198 views1 answer
How to use query in nosql
SQL
0 vote206 views1 answer
Sql delete caracter list
SQL
14 votes205 views2 answers
Oracle add column with default value
SQL
2 votes271 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote213 views1 answer
Mysql add text to existing field
SQL
0 vote205 views1 answer
Mysql check datetime equals date
SQL
0 vote203 views1 answer
Sql beginning of previous month
SQL
3 votes200 views1 answer
Sql datetime as date
SQL