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 vote122 views4 answers
Sequelize migration default value
SQL
2 votes123 views1 answer
Drop table purge
SQL
0 vote136 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote127 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote130 views1 answer
How to get inserted id in sql server
SQL
0 vote133 views1 answer
Default value false mysql
SQL
5 votes148 views6 answers
Sql foreign key
SQL
0 vote126 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes137 views1 answer
Oracle to_char number format percentage
SQL
2 votes128 views2 answers
Postgres select duplicate columns
SQL