WITH TT(시, 구, 동, 아이템) AS (
      SELECT '서울시', '도봉구', '방학1동', '스타벅스' FROM DUAL UNION ALL
      SELECT '서울시', '도봉구', '방학1동', '이디야' FROM DUAL UNION ALL
      SELECT '서울시', '도봉구', '방학1동', '탐앤탐스' FROM DUAL UNION ALL
      SELECT '서울시', '도봉구', '방학2동', '스타벅스' FROM DUAL UNION ALL
      SELECT '서울시', '도봉구', '방학2동', '이디야' FROM DUAL UNION ALL
      SELECT '서울시', '도봉구', '방학2동', '커피빈' FROM DUAL UNION ALL
      SELECT '서울시', '노원구', '쌍문1동', '커피빈' FROM DUAL UNION ALL
      SELECT '서울시', '노원구', '쌍문2동', '커피빈' FROM DUAL UNION ALL
      SELECT '서울시', '노원구', '쌍문3동', '커피빈' FROM DUAL
)
SELECT 시,구,아이템
FROM TT
GROUP BY 시,구,아이템
HAVING COUNT(*) > 1
;