mysql 区间分组统计

select elt(interval(c.money, 0, 1000, 2000, 3000, 4000, 5000), 'less 1000', '1000to2000', '2000to3000', '3000to4000','4000to5000') as level, count(c.id) as cnt from (select sum(a.money) as money,b.id from 表1 as a,表2 as b where a.uid = b.id group by b.id) as c group by elt(interval(c.money, 0, 1000, 2000, 3000, 4000, 5000), 'less 1000', '1000to2000', '2000to3000', '3000to4000','4000to5000')

－－－－－－－－－－－－－－

1. select   
2. sum(  
3.          case   
4.          when examination_score between 90 and 100   
5.          then 1 else 0   
6.          end  
7.        ) as 优秀,  
8. sum(  
9.         case   
10.         when examination_score between 80 and 90   
11.         then 1 else 0   
12.        end  
13.        ) as 良好  
14. from el_test_info