数据库表结构如下:
表t_stick_daily
stick_count是整数类型,可能的值在0-20之间,现有需求:统计0次,1-3次、4-6次、7-9次、10-12次、13次以上,这几个区间各有多少组数据
sql如下
select elt(interval(d.stick_count,0,1,4,7,10,13),'0', '1to3','4to6', '7to9','10to12', 'more13')
as stickLevel, count(*) as total from t_stick_daily d
group by elt(interval(d.stick_count,0,1, 4, 7, 10, 13),'0' '1to3','4to6', '7to9','10to12', 'more13')
运行结果