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 vote324 views1 answer
Create sample data postgresql
SQL
0 vote326 views1 answer
Why mysql is used?
SQL
0 vote325 views2 answers
Sql server select where date
SQL
0 vote370 views1 answer
Declare or use variable in snowflake
SQL
0 vote313 views1 answer
Postgresql newline character
SQL
20 votes384 views4 answers
How to find average in sql
SQL
0 vote327 views1 answer
Sql row number in result set
SQL
27 votes359 views5 answers
Mysql set password for user
SQL
0 vote352 views1 answer
Sql make sure every user is unqiuew
SQL
1 vote337 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL