--mysqly原语句
SELECT
index_name,
COUNT(DISTINCT (id_card)) AS applyCount,
count(index_id) AS apasInfoCount,
SUM(CASE checked WHEN 'N' THEN 0 WHEN 'Y' THEN 1 END) transactCount, CAST(AVG(check_day) AS decimal (10, 2)) AS checkDayCount, SUM(extended_day > 0) AS extendedDayCount,
index_id
FROM XSM.xjm_material_check
WHERE index_id != '33020018'
GROUP BY index_id
--达梦执行报错
-3506: 第9 行附近出现错误:
无效的参数定义