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

2 votes236 views1 answer
Select from array in psql
SQL
0 vote208 views1 answer
Mysql date format unix timestamp
SQL
0 vote198 views1 answer
How to get n result in sql
SQL
0 vote201 views2 answers
Script all indexes in a database
SQL
0 vote202 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
10 votes210 views2 answers
Show tables in schema oracle
SQL
0 vote302 views3 answers
Get count of null in column sql
SQL
0 vote217 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote211 views1 answer
C# execute transact sql
SQL
1 vote196 views1 answer
Oracle db create new schema
SQL