-- USED_GOODS_BOARD: BOARD_ID, WRITER_ID, TITLE, CONTENTS, PRICE, CREATED_DATE, STATUS, VIEWS
-- USED_GOODS_USER: USER_ID, NICKNAME, CITY, STREET_ADDRESS1, STREET_ADDRESS2, TLNO
WITH USER_BOARD_COUNT AS (
SELECT
WRITER_ID,
COUNT(WRITER_ID) AS CNT
FROM USED_GOODS_BOARD
GROUP BY WRITER_ID
)
SELECT
T1.USER_ID,
T1.NICKNAME,
CONCAT(T1.CITY, ' ', T1.STREET_ADDRESS1, ' ', T1.STREET_ADDRESS2) AS '전체 주소',
CONCAT(SUBSTRING(T1.TLNO, 1, 3), '-', SUBSTRING(T1.TLNO, 4, 4), '-', SUBSTRING(T1.TLNO, 8, 4)) AS TLNO
FROM USED_GOODS_USER AS T1
JOIN USER_BOARD_COUNT AS T2
ON T1.USER_ID = T2.WRITER_ID
WHERE T2.CNT >= 3
ORDER BY 1 DESC;