코테 준비/SQL

프로그래머스_조건에 맞는 사용자 정보 조회하기

imsmile2000 2023. 11. 16. 19:51

CONCAT, SUBSTR 중요!

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