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 vote170 views1 answer
Postgres grant read only access to database
SQL
13 votes164 views2 answers
Mysql order by multiple columns
SQL
0 vote177 views1 answer
Groupby sort sql hive
SQL
1 vote135 views1 answer
Ms sql how to see active job current run time
SQL
0 vote215 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote168 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote172 views1 answer
Sql server express download
SQL
1 vote172 views1 answer
How to remove identity from a column in sql server
SQL
1 vote168 views1 answer
Create another table from existing table sql oracle
SQL
0 vote185 views1 answer
HOW to select specific table data from an mysql databse server:
SQL