SQL 查询语句：计算差旅月工时和旷工时长

SELECT name, bm, ROUND( SUM( CASE WHEN bc = '自由工时' AND gzsc != 0 AND cqts = 1 THEN gzsc WHEN bc = '自由工时' AND gldspd LIKE '%出差%' AND gzsc = 0 AND cqts = 1 THEN 480 WHEN bc = '自由工时' AND gzsc = 0 AND cqts = 0 AND chuchai = 1 THEN 480 WHEN bc <> '自由工时' AND gldspd LIKE '%出差%' THEN 480 ELSE 0 END )/60.0,1) AS 差旅月工时, SUM( CASE WHEN bc LIKE '%白车身%' AND sb1dksj = '缺卡' AND xb1dksj = '缺卡' AND gldspd IS NULL THEN 480 ELSE 0 END )/60.0 AS 旷工kg FROM Test_kqzhb WHERE rq BETWEEN '2023-09-01' AND '2023-09-25' and name='周新威' GROUP BY name, bm;