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 vote155 views1 answer
Right outer vs left outer join
SQL
0 vote168 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
-1 vote172 views1 answer
Module operator in oracle sql
SQL
0 vote211 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote167 views1 answer
Vagrant mysql downgrade version
SQL
3 votes243 views1 answer
Sql datetime as date
SQL
0 vote193 views1 answer
Zsh: command not found: mysql mamp
SQL
-1 vote157 views1 answer
Sql syntax create timestamp column
SQL
1 vote151 views1 answer
Sql eliminare un record
SQL
2 votes148 views1 answer
How to add where command in update comand with joins
SQL