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 vote282 views1 answer
Oracle create program if not exists
SQL
15 votes351 views3 answers
Postgresql change column type
SQL
0 vote200 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote204 views1 answer
Sql check if column exists
SQL
7 votes210 views1 answer
Oracle reset sequence
SQL
0 vote221 views1 answer
For row in sql database python loop
SQL
5 votes188 views1 answer
Oracle scan source ddl
SQL
0 vote214 views1 answer
How to select an index in oracle sql
SQL
1 vote207 views1 answer
Psql show with user is logged in
SQL
13 votes188 views2 answers
Display users in mysql
SQL