select C.GZ_YM AS 缴费年月, SUM(C.C21163) AS 养老保险单位缴纳, SUM(C.C2144) AS 养老保险个人缴纳, SUM(C.C21163+C.C2144) AS 养老合计, SUM(C.C21165) AS 失业保险单位缴纳, SUM(C.C2153) AS 失业保险个人缴纳, SUM(C.C21165+ C.C2153) AS 失业合计, SUM(C.C21166) AS 工伤保险单位缴纳, SUM(C. C21164) AS 医疗保险单位缴纳, SUM(C.C2147) AS 医疗保险个人缴纳, SUM( C.C21164+C.C2147) AS 医疗合计, SUM(C.C21163+C.C21165+ C.C21164+ C.C21166) AS 单位缴纳总合计, SUM(C.C2144+C.C2153+C.C2147) AS 个人缴纳总合计, SUM(C.C21163+C.C21165+ C. C21164+ C.C21166+C.C2144+C.C2153+C.C2147) AS 总合计 from c21 left join b01 on c21.dept_id = b01.dept_id where b01.dept_code like (SELECT A.DEPT_CODE FROM B01 A WHERE A.Dept_ID = B01.DEPT_ID )+'%' AND GRADE = 2 GROUP BY C.GZ_YM

以下是修改后的查询语句：

SELECT 
    C.GZ_YM AS 缴费年月,
    SUM(C.C21163) AS 养老保险单位缴纳,
    SUM(C.C2144) AS 养老保险个人缴纳,
    SUM(C.C21163+C.C2144) AS 养老合计,
    SUM(C.C21165) AS 失业保险单位缴纳,
    SUM(C.C2153) AS 失业保险个人缴纳,
    SUM(C.C21165+  C.C2153) AS 失业合计,
    SUM(C.C21166) AS 工伤保险单位缴纳,
    SUM(C. C21164) AS 医疗保险单位缴纳,
    SUM(C.C2147) AS 医疗保险个人缴纳,
    SUM( C.C21164+C.C2147) AS 医疗合计,
    SUM(C.C21163+C.C21165+ C.C21164+ C.C21166) AS 单位缴纳总合计,
    SUM(C.C2144+C.C2153+C.C2147) AS 个人缴纳总合计,
    SUM(C.C21163+C.C21165+ C. C21164+ C.C21166+C.C2144+C.C2153+C.C2147) AS 总合计
FROM c21 
LEFT JOIN b01 ON c21.dept_id = b01.dept_id 
WHERE b01.dept_code LIKE (SELECT A.DEPT_CODE FROM B01 A WHERE A.Dept_ID = B01.DEPT_ID)+'%' 
AND GRADE = 2
GROUP BY C.GZ_YM

在这个查询中，我添加了一个条件来限制 `b01.dept_code` 的值与子查询结果匹配，并且增加了 `GRADE = 2` 的条件。再次强调，请确保在运行查询之前仔细检查和验证查询语句。