SELECT REPLACE(cdisease.diagcode, ' ', '') as icd10, REPLACE(cdisease.diseasethai, ',', '') as t_name, SUM(CASE WHEN sex='1' THEN result ELSE 0 END) AS male, SUM(CASE WHEN sex='2' THEN result ELSE 0 END) AS female, SUM(CASE WHEN sex not in(1,2) THEN result ELSE 0 END) AS sex_error, SUM(result) AS total FROM s_death_diag_sex_age INNER JOIN cdisease ON s_death_diag_sex_age.diagcode = cdisease.diagcode WHERE id='8881445af732eb166fa2470ba5046956' AND b_year = '2562' AND SUBSTR(areacode,1,2)='77' AND cdisease.diagcode BETWEEN 'i20' AND 'i259' GROUP BY cdisease.diagcode, cdisease.diseasethai HAVING LEFT(cdisease.diagcode,1) <> 'Z'