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

-1 vote288 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
12 votes263 views4 answers
SQL Where
SQL
0 vote299 views1 answer
Mysql multiple group by
SQL
0 vote321 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote283 views1 answer
Mysql foreach insert
SQL
0 vote280 views1 answer
Order by ip address sql
SQL
2 votes309 views5 answers
Install postgresql 10 centos 7
SQL
2 votes305 views1 answer
Creating a view SQL
SQL
1 vote228 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote282 views3 answers
Find below average salary in sql
SQL