[프로그래머스/Oracle] Lv3. 조건에 맞는 사용자 정보 조회하기

| 문제

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

프로그래머스

 

| 풀이

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