[프로그래머스, Lv.3] 조건에 맞는 사용자 정보 조회하기 (mysql)

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

프로그래머스

728x90

---

SELECT user_id, nickname, CONCAT(city, ' ', street_address1, ' ', street_address2) AS 전체주소, CONCAT(SUBSTRING(tlno, 1, 3), '-', SUBSTRING(tlno, 4, 4), '-', SUBSTRING(tlno, 8, 4)) AS 전화번호
FROM used_goods_user
WHERE user_id IN (
    SELECT writer_id
    FROM used_goods_board
    GROUP BY writer_id
    HAVING COUNT(writer_id) >= 3
)
ORDER BY user_id DESC