为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:1-3-26-2023.08.04-198058-20046-SEC
【操作系统】：Kylin Linux V10
【CPU】:Kunpeng-920
【问题描述】*：达梦数据库执行SQL第97 行附近出现错误[-2111]: 无效的列名[assetName]

代码：
SELECT
COUNT(*)
FROM
(
(
SELECT
a.TENANTRY_NAME AS tenantryName,
a.TENANTRY_CERTIFICATE_NO AS tenantryCertificateNo,
a.TENANTRY_LEGAL_REPRESENTATIVE AS tenantryLegalRepresentative,
a.TENANTRY_CONTACTS_PHONE AS tenantryContactsPhone,
a.HIRE_AREA AS hireArea,
a.rent_univalent AS rentUnivalent,
a.MONTH_RENT_DISCOUNT AS monthRentDiscount,
a.PAY_TYPE AS payType,
a.MONTH_RENT_TOTAL AS monthRentTotal,
a.ANNUAL_RENT_TOTAL AS annualRentTotal,
a.HIRE_BEGIN_TIME AS hireBeginTime,
a.HIRE_END_TIME AS hireEndTime,
a.HIRE_UNIVALENT_INCREASE AS hireUnivalentIncrease,
a.HIRE_UNIVALENT_INCREASE_UNIT AS hireUnivalentIncreaseUnit,
a.HIRE_UNIVALENT_INCREASE_N1 AS hireUnivalentIncreaseN1,
a.HIRE_UNIVALENT_INCREASE_N2 AS hireUnivalentIncreaseN2,
a.DECISION_TIME AS decisionTime,
a.HIRE_ACCORDING AS hireAccording,
d.LEADER_ORG_NAME AS leaderOrgName,
'1' AS signStatus,
wm_concat(
DISTINCT CASE WHEN c.full_name IS NOT NULL
AND c.full_name != '' THEN CONCAT(c.project_name, '-', c.full_name) ELSE c.project_name END
) AS assetName
FROM
base_space_management.sm_contract_info a
LEFT JOIN base_space_management.sm_contract_asset b ON b.CONTRACT_ID = a.CONTRACT_ID
AND b.tenant_id = 1643078098058637313
LEFT JOIN base_space_management.sm_asset_info c ON b.ASSET_ID = c.ASSET_ID
AND c.tenant_id = 1643078098058637313
LEFT JOIN base_space_management.sm_draft_settled_enterprise d ON d.DRAFT_SETTLED_ENTERPRISE_ID = a.DRAFT_SETTLED_ENTERPRISE_ID
AND d.tenant_id = 1643078098058637313
WHERE
a.del_flag = '0'
AND a.tenant_id = 1643078098058637313
GROUP BY
a.CONTRACT_ID
HAVING
assetName LIKE CONCAT('%', 1, '%')
ORDER BY
a.update_time DESC,
a.create_time DESC
)
UNION
(
SELECT
a.ENTERPRISE_NAME AS tenantryName,
a.CREDIT_CODE AS tenantryCertificateNo,
'1' AS tenantryLegalRepresentative,
d.TENANTRY_CONTACTS_PHONE AS tenantryContactsPhone,
a.HIRE_AREA AS hireArea,
a.MONTH_RENT_UNIVALENT AS rentUnivalent,
a.MONTH_RENT_DISCOUNT AS monthRentDiscount,
a.PAY_TYPE AS payType,
a.MONTH_RENT_TOTAL AS monthRentTotal,
a.ANNUAL_RENT_TOTAL AS annualRentTotal,
a.HIRE_BEGIN_TIME AS hireBeginTime,
a.HIRE_END_TIME AS hireEndTime,
a.HIRE_UNIVALENT_INCREASE AS hireUnivalentIncrease,
a.HIRE_UNIVALENT_INCREASE_UNIT AS hireUnivalentIncreaseUnit,
a.HIRE_UNIVALENT_INCREASE_N1 AS hireUnivalentIncreaseN1,
a.HIRE_UNIVALENT_INCREASE_N2 AS hireUnivalentIncreaseN2,
a.DECISION_TIME AS decisionTime,
a.HIRE_ACCORDING AS hireAccording,
a.LEADER_ORG_NAME AS leaderOrgName,
a.SIGN_STATUS AS signStatus,
wm_concat(
DISTINCT CASE WHEN c.full_name IS NOT NULL
AND c.full_name != '' THEN CONCAT(c.project_name, '-', c.full_name) ELSE c.project_name END
) AS assetName
FROM
base_space_management.sm_draft_settled_enterprise a
LEFT JOIN base_space_management.sm_draft_settled_enterprise_asset b ON b.DRAFT_SETTLED_ENTERPRISE_ID = a.DRAFT_SETTLED_ENTERPRISE_ID
AND b.tenant_id = 1643078098058637313
LEFT JOIN base_space_management.sm_asset_info c ON b.ASSET_ID = c.ASSET_ID
AND c.tenant_id = 1643078098058637313
LEFT JOIN base_space_management.sm_contract_info d ON d.DRAFT_SETTLED_ENTERPRISE_ID = a.DRAFT_SETTLED_ENTERPRISE_ID
AND d.tenant_id = 1643078098058637313
WHERE
a.SIGN_STATUS != 1
AND a.del_flag = '0'
AND a.tenant_id = 1643078098058637313
GROUP BY
a.DRAFT_SETTLED_ENTERPRISE_ID
HAVING
assetName LIKE CONCAT('%', 111111, '%')
ORDER BY
a.update_time DESC,
a.create_time DESC
)
) TOTAL