[SQL] 조건에 맞는 사용자 정보 조회하기

반응형

 

 

https://school.programmers.co.kr/learn/courses/30/lessons/164670

프로그래머스

 

 

정답 쿼리

SELECT USER_ID, NICKNAME, CONCAT(CITY, " ", STREET_ADDRESS1, " ",STREET_ADDRESS2) 전체주소,
    CONCAT(
    SUBSTR(TLNO, 1, 3), '-', 
    SUBSTR(TLNO, 4, 4), '-', 
    SUBSTR(TLNO, 8, 4)
  ) AS 전화번호
FROM USED_GOODS_USER
WHERE USER_ID IN (
    SELECT B.WRITER_ID
    FROM USED_GOODS_BOARD B
    JOIN USED_GOODS_USER U
        ON B.WRITER_ID = U.USER_ID
    GROUP BY B.WRITER_ID
    HAVING COUNT(B.WRITER_ID) >= 3
)
ORDER BY USER_ID DESC