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 vote431 views1 answer
How to put value in variable mysql
SQL
28 votes335 views4 answers
Mysql delete database
SQL
0 vote345 views1 answer
Opensuse start MySQL
SQL
0 vote365 views1 answer
Oracle current session details
SQL
1 vote364 views1 answer
List all triggers in SQL Server
SQL
1 vote352 views1 answer
Importance of comment in mysql
SQL
3 votes381 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
13 votes353 views5 answers
Select last row mysql
SQL
0 vote358 views2 answers
How to know the character set of an oracle databes
SQL
0 vote390 views1 answer
Selecting Multiple Columns in SQL
SQL