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 vote332 views1 answer
Get clob size oracle
SQL
16 votes292 views3 answers
Order by sql query
SQL
0 vote317 views1 answer
Oracle create job if not exists
SQL
2 votes331 views1 answer
Sql percentage with % rounded down
SQL
1 vote315 views2 answers
Mysql allow remote connections
SQL
0 vote297 views3 answers
Drop multiple columns in sql
SQL
0 vote313 views1 answer
Sql query to return field name of a table
SQL
1 vote312 views1 answer
Md5 encryption for existing records
SQL
0 vote317 views1 answer
SAP Return
SQL
-3 votes332 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL