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

23 votes111 views6 answers
Create table sql server
SQL
1 vote103 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote92 views1 answer
Update using case in mysql
SQL
6 votes80 views3 answers
Can you update NULL in sql
SQL
1 vote109 views3 answers
Rows, INSERT INTO
SQL
0 vote94 views1 answer
Postgres data location
SQL
0 vote102 views2 answers
Sql server Insert Into table
SQL
1 vote97 views1 answer
Sqlite create index
SQL
1 vote120 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote56 views1 answer
How to get last client id sql
SQL