SELECT c.area_id, if(c.area_id is null, '전체', c.name) name, IF(c.enabled = 'Y', 'Y', '-') enabled, SUM(1) T, SUM(IF(a.enabled = 'Y', 1, 0)) TY, SUM(IF(a.area_type = 'S' AND a.enabled = 'Y', 1, 0)) SY, SUM(IF(a.area_type = 'S' AND a.enabled = 'N', 1, 0)) SN, SUM(IF(a.area_type = 'H' AND a.enabled = 'Y', 1, 0)) HY, SUM(IF(a.area_type = 'H' AND a.enabled = 'N', 1, 0)) HN FROM Area a JOIN Area c ON ..