SELECT 区域, COUNT(ID) AS 应出勤人数, SUM(case WHEN 是否出勤=-1 then 1 else 0 end) AS 实际出勤人数, (FormatPercent(实际出勤人数/应出勤人数,2)) AS 出勤率
粗体的部分报错
SELECT 区域, COUNT(ID) AS 应出勤人数, SUM(case WHEN 是否出勤=-1 then 1 else 0 end) AS 实际出勤人数, (FormatPercent(实际出勤人数/应出勤人数,2)) AS 出勤率
粗体的部分报错