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 vote114 views1 answer
Sql trim whitespace
SQL
0 vote158 views1 answer
How to get data from 2 database
SQL
0 vote134 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote145 views1 answer
Difference between db.query and db.execute
SQL
0 vote139 views2 answers
Python mysql create table if not exists
SQL
1 vote138 views1 answer
Sql select table header
SQL
5 votes139 views2 answers
Sql server check port number
SQL
0 vote132 views1 answer
Sqlite update only if greater
SQL
2 votes132 views1 answer
Oracle generated column
SQL
0 vote135 views1 answer
Power bi union columns
SQL