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

• CONCAT(,) + SUBSTR(STR, 시작, 글자수)

-- 코드를 입력하세요
SELECT B.USER_ID, B.NICKNAME, CONCAT(B.CITY, " ", B.STREET_ADDRESS1, " ", B.STREET_ADDRESS2) AS 전체주소, CONCAT(SUBSTR(B.TLNO, 1, 3), "-", SUBSTR(B.TLNO, 4, 4), "-", SUBSTR(B.TLNO, 8, 4)) AS 전화번호
FROM USED_GOODS_BOARD AS A JOIN USED_GOODS_USER AS B ON A.WRITER_ID = B.USER_ID
GROUP BY USER_ID HAVING COUNT(A.WRITER_ID) >= 3
ORDER BY B.USER_ID DESC;