为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DM管理工具 V8 (Build 2021.10.21)
【操作系统】：Windows
【CPU】:
【问题描述】*：总共1个语句正依次执行…

[执行语句1]:
select count(*) ,
s_tree.NODENAME AS ‘中队名称’,
zic.CHECKLIST_TPL_NAME AS ‘检查单模板名称’,
zic.CHECKLIST_CODE AS ‘检查单号’,
zic.INSPECT_ADDRESS AS ‘检查地点’,
zic.CREATE_TIME AS ‘创建时间’,
CASE
zil.OBJECT_TYPE
WHEN 10 THEN
zil.CITIZEN_NAME
WHEN 20 THEN
zil.SELFEMPLOYED_NAME
WHEN 30 THEN
zil.ORGAN_NAME
WHEN 40 THEN
zil.OTHER_ORGAN_COMPANY_NAME
END AS ‘当事人名称’,
CASE
zic.IS_CLOSED
WHEN 1 THEN
‘已办结’ ELSE ‘未办结’
END AS ‘办结状态’,
CASE
zic.IS_PASS
WHEN 0 THEN
‘未检查’
WHEN 1 THEN
‘合格’ ELSE ‘不合格’
END AS ‘检查结果’,
zic.INSPECT_START_DATE AS ‘检查日期’
from zf_inspect_checklist zic
LEFT JOIN zf_inspect_base zib ON zib.ID = zic.INSPECT_ID
LEFT JOIN zf_inspect_litigant zil ON zic.ID = zil.CHECKLIST_TASK_ID
LEFT JOIN s_treenode s_tree ON zib.DEPT_ID = s_tree.NODEID
group by s_tree.NODENAME;
执行失败(语句1)
第 2 行, 第 34 列[']附近出现错误[-2007]:
语法分析出错

1条语句执行失败