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

6 votes150 views1 answer
What is where clause in sql
SQL
0 vote165 views2 answers
Faster mysql imports
SQL
0 vote282 views2 answers
Mysql insert rows to another database
SQL
1 vote141 views1 answer
Error code 1055
SQL
1 vote282 views1 answer
Import sql file from laravel
SQL
9 votes150 views2 answers
Sql server check table exists
SQL
5 votes193 views4 answers
Mysql on duplicate key update
SQL
0 vote149 views1 answer
Create schema sql server
SQL
0 vote157 views1 answer
Mysql Like(searching in the string)
SQL
37 votes192 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL