MySQL将数据按某一字段的范围分组显示，SQL语句怎么写？

Question

员工表（emp）按工资（sal）分组（3000以下，3000至5000,5000至10000和10000以上），然后统计人数。SQL语句该怎么写？

Answer 1

select elt(interval(sal,0,3000,5000,10000,10000),"1","2","3","4","5") as sort ,count(*) 
from emp group by sort;