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

• 문제
  
• 정답

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

• 결과