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

2 votes139 views1 answer
Sql select min value from multiple columns
SQL
2 votes198 views3 answers
Row number mysql
SQL
0 vote187 views1 answer
Sqlite insert or update
SQL
27 votes197 views6 answers
Set password mysql
SQL
9 votes175 views2 answers
Default number in sql
SQL
0 vote196 views2 answers
Oracle create tablespace autoextend
SQL
1 vote180 views1 answer
Input in mysql
SQL
0 vote197 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote187 views1 answer
What is mysql_pconnect
SQL
0 vote204 views2 answers
PostgreSQL having
SQL