WITH T (STRT,END,TM) AS ( SELECT '대구','대구', 10 FROM DUAL UNION ALL SELECT '서울','대구', 11 FROM DUAL UNION ALL SELECT '부산','서울', 12 FROM DUAL UNION ALL SELECT '대구','서울', 11 FROM DUAL ) SELECT STRT "목적지" , COUNT(CASE WHEN END='대구' THEN 1 END) "대구" , COUNT(CASE WHEN END='서울' THEN 1 END) "서울" FROM T GROUP BY STRT ORDER BY DECODE(STRT,'대구',1,'서울',2,3)