https://programmers.co.kr/learn/courses/30/lessons/77487

📒 문제

---

📒 예시

---

🌻 코드

SELECT ID,NAME,HOST_ID FROM PLACES
WHERE HOST_ID IN (SELECT HOST_ID FROM PLACES
          GROUP BY HOST_ID
          HAVING COUNT(*) >=2) --소유한 장소가 2개 이상

---

💡 정리하기

👉 Group by와 Having 활용하기