==================现有数据结构如下 :
count title age
2 Sales Representative 34
1 Sales Representative 26
1 Inside Sales Coordinator 33
1 Inside Sales Coordinator 25
1 sales manager 25
1 Sales Manager 35
1 Sales Manager 28
1 Inside Sales Coordinator 26
1 Sales Representative 36
2 Sales Representative 31
1 Inside Sales Coordinator 32
1 Inside Sales Coordinator 28
1 Sales Representative 35
3 Sales Representative 27
1 Sales Representative 25
===========================想得到根据title 分组后,在根据age分段(20~25,26~30。)中 count的和:
title 20~25 26~30 .... Sales Representative 1 4
Inside Sales Coordinator 0 3 .....
.....
count title age
2 Sales Representative 34
1 Sales Representative 26
1 Inside Sales Coordinator 33
1 Inside Sales Coordinator 25
1 sales manager 25
1 Sales Manager 35
1 Sales Manager 28
1 Inside Sales Coordinator 26
1 Sales Representative 36
2 Sales Representative 31
1 Inside Sales Coordinator 32
1 Inside Sales Coordinator 28
1 Sales Representative 35
3 Sales Representative 27
1 Sales Representative 25
===========================想得到根据title 分组后,在根据age分段(20~25,26~30。)中 count的和:
title 20~25 26~30 .... Sales Representative 1 4
Inside Sales Coordinator 0 3 .....
.....
sum(case when age>=20 and age<=25 then 1 else 0 end) "20~25",
sum(case when age>=26 and age<=30 then 1 else 0 end) "26~30"
........................
from bb1 group by title;