如何根据分值的区间 ，去统计每个地点下，每种礼品的个数？
当FSCORE在 1-49.9 ，50-99.9 ，100-149.9 这三个区间时，
分别统计出每个地点下每个区间的礼品的发放件数
改一下字段和表名 试试行不行行
select
t1.aa,t1.地点,
count(礼品)over(partition by aa,地点 ) as cnt
from
(
select t.*,
case when t.FSCORE>=1 and t.FSCORE<49.9 then '1-49.9'
when t.FSCORE>=50 and t.FSCORE<99.9 then '50-99.9'
when t.FSCORE>=100 and t.FSCORE<149.9 then '100-149.9'
else '' end aa
from table t ) t1
group by t1.aa,t1.地点
SELECT T.GROUP_,COUNT(T.GROUP_) [SL] FROM (
SELECT (CAS WHEN FSCORE>=1 AND FSCORE<50 THEN '1' WHEN FSCORE>=50 AND FSCORE<100 THEN '2' WHEN FSCORE>=100 AND FSCORE<450 THEN '3' ELSE '4' END) [GROUP_] FROM 表) T GROUP BY T.GROUP_
参考 casewhen和count配合使用
https://blog.csdn.net/baidu_19338587/article/details/102722975
https://blog.csdn.net/weixin_39723544/article/details/80175662
1min目标场景问卷
立即参与
