[Programmers 2021 Dev-Matching: 웹 백엔드 개발자(상반기)] 헤비 유저가 소유한 장소

James Jung·2021년 7월 30일
0
post-thumbnail

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

Code link
https://github.com/JamesJung01/Programmers_sql_kit/blob/main/heavy-user.sql

SELECT ID, NAME, HOST_ID
FROM PLACES
WHERE HOST_ID IN (SELECT HOST_ID 
      FROM PLACES
      GROUP BY HOST_ID
      HAVING COUNT(HOST_ID) >= 2)
ORDER BY ID;

0개의 댓글