[Algorithm_SQL] 헤비 유저가 소유한 장소 (Success)

프로그래머스

🙂 확인 사항

1. PLACES 테이블

2. 헤비 유저

3. 아이디 내림차순 정렬

 

 

📝 Language: Oracle

  SELECT * 
    FROM PLACES
   WHERE HOST_ID IN (
         SELECT HOST_ID 
           FROM PLACES
       GROUP BY HOST_ID
         HAVING COUNT(HOST_ID) > 1)
ORDER BY ID
;
 

* 중첩 SubQuery

 

WITH CONDITIONS AS (
      SELECT HOST_ID 
        FROM PLACES
    GROUP BY HOST_ID
      HAVING COUNT(HOST_ID) > 1
)
  SELECT P.*
    FROM PLACES P
    JOIN CONDITIONS C 
      ON P.HOST_ID = C.HOST_ID
ORDER BY P.ID
;
 

* 공통 표현식 + Inner Join

 

WITH CONDITIONS AS (
      SELECT HOST_ID 
        FROM PLACES
    GROUP BY HOST_ID
      HAVING COUNT(HOST_ID) > 1
)
  SELECT *
    FROM PLACES
   WHERE HOST_ID IN (SELECT HOST_ID FROM CONDITIONS)
ORDER BY ID
;
 

* 공통 표현식 + 중첩 Sub Query

 

⭐Oracle SQL에서는 IN 절 안에 직접 서브쿼리를 넣어야하므로, 공통표현식을 서브쿼리 형태로 작성

 

 

 

🔗 소스 코드
GitHub