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 vote120 views1 answer
Create table like sql
SQL
0 vote117 views1 answer
Sql query wordpress export post
SQL
0 vote145 views1 answer
Many rows to 1 string mysql
SQL
0 vote110 views1 answer
Run mssql server terminal
SQL
0 vote111 views1 answer
Mssql current date
SQL
0 vote102 views1 answer
Output to file mysql
SQL
5 votes190 views1 answer
Oracle asynchronous procedure
SQL
0 vote117 views1 answer
Update top 100 order by sql server
SQL
0 vote109 views2 answers
How to get json data mysql
SQL
0 vote110 views1 answer
Oracle last character of string
SQL