统计 记录中 od.diff_days >0/ =0 / <0 的记录分别有多少

统计 记录中 od.diff_days >0/ =0 / <0 的记录分别有多少

 

SELECT 
    od.carrier_code,
    'CW27' week,
    od.pickup_date,
    COUNT(DISTINCT od.asn_code) asn_num,
    count(CASE WHEN od.diff_days > 0 THEN 0 END) AS delay_num,
    count(CASE WHEN od.diff_days = 0 THEN 0 END) AS ontime_num,
    count(CASE WHEN od.diff_days < 0 THEN 0 END) AS early_num
FROM odd_detail od
WHERE 1=1
GROUP BY od.carrier_code,od.pickup_date