sql error [ SELECT AMPHUR_NAME, LEFT(CHAT,4) AS A_CODE
,SUM(CASE WHEN PERSON_ID IS NOT NULL THEN 1 ELSE 0 END) as n_all
FROM data_tran_null_256704 WHERE (data_tran_null_256704.BIRTHDATE LIKE '2567%' OR data_tran_null_256704.BIRTHDATE LIKE '2566%') AND PRIMARYPROVINCE=3500
GROUP BY A_CODE
UNION ALL
SELECT 'รวม' AMPHUR_NAME,'' AS A_CODE
,SUM(CASE WHEN PERSON_ID IS NOT NULL THEN 1 END)
FROM data_tran_null_256704 WHERE (data_tran_null_256704.BIRTHDATE LIKE '2567%' OR data_tran_null_256704.BIRTHDATE LIKE '2566%') AND PRIMARYPROVINCE=3500
]