SQL查询语句：计算旷工和差旅月工时（含自由工时条件）

请使用以下SQL查询语句来实现您的需求：

SELECT
    name,
    bm,
    SUM(
        CASE
            WHEN bc LIKE '%白车身%' AND sb1dkjg = '缺卡' AND xb1dkjg = '缺卡' AND (gldspd IS NULL OR gldspd = '') THEN 480
            WHEN bc = '自由工时' AND sb1dksj IS NULL AND xb1dksj IS NULL AND gldspd IS NULL THEN 480
            ELSE 0
        END
    )/60.0 AS 旷工,
    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 差旅月工时
FROM Test_kqzhb
WHERE rq BETWEEN '2023-09-01' AND '2023-09-25' and name='陈建'
GROUP BY name, bm;

在以上查询语句中，我添加了一个新的条件判断，当班次为'自由工时'且sb1dksj和xb1dksj为空且gldspd为空时，将累加8小时作为旷工时间。