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 vote320 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
15 votes315 views2 answers
How to drop database name in postgresql
SQL
0 vote333 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
7 votes380 views1 answer
Buy forge mods server hosting
SQL
0 vote334 views1 answer
Sql select min
SQL
0 vote337 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote346 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote354 views1 answer
Postgre query date
SQL
0 vote347 views1 answer
Sql column contains special character
SQL
0 vote307 views1 answer
MySQL FIND_IN_SET()
SQL