SELECT MONTH(ts) as month_num, CASE when pay_amount/100'199' then '门槛1＜199' when pay_amount/100='199' and pay_amount/100'299' then '199≤门槛2＜299' when pay_amount/100='299' and pay_amount/100'399' then '299≤门槛3＜399' when pay_amount/100='399' and pay_amount/100'499' then '399≤门槛4＜499' when pay_amount/100='499' and pay_amount/100'599' then '499≤门槛5＜599' when pay_amount/100='599' then '门槛6≥599' ELSE null END as type, -- pay_amount/100 as total_pay_amount, AVG(total_weight) as avg_weight, AVG(logistics_fee)/100 AS avg_logistics_fee, SUM(CASE WHEN CAST(logistics_fee AS DECIMAL(10,4)) = 0.0000 THEN 1 ELSE 0 END) AS no_logistics_fee_count, SUM(CASE WHEN CAST(logistics_fee AS DECIMAL(10,4)) 0.0000 THEN 1