帆软用户soXPfpmWb7(提问者)还是会有错 SELECT
SUM(商) /5 AS 整体平均超时时间
FROM(
SELECT
fd,
SUM(DATEDIFF(day, shsj, khsjjd)) / COUNT(*) AS 商
FROM uf_grjh_rc
where
${if(len(月份) == 0, "", "substring(shsj,6,2) in ('"+repalce(月份,",","','")+"') AND")}
${if(len(客户) == 0, "", "khjc = '" + 客户 + "' AND")}
(psjl = '通过' OR psjl = '条件通过')
AND fd IN ('PA', 'TA', 'TB', 'TC', 'TSOP')
AND khsjjd IS NOT NULL
AND shsj IS NOT NULL
AND left(shsj,4)='${年度}'
GROUP BY fd
) AS subquery