Programmers

MySQL) 오랜기간 보호한 동물

SELECT I.NAME, I.DATETIMEFROM ANIMAL_INS IWHERE I.ANIMAL_ID NOT IN (SELECT ANIMAL_ID FROM ANIMAL_OUTS)ORDER BY I.DATETIME LIMIT 3

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

SELECT U.USER_ID, U.NICKNAME, CONCAT(U.CITY, ' ',U.STREET_ADDRESS1, ' ', U.STREET_ADDRESS2) AS 전체주소, INSERT(INSERT(U.TLNO, 8, 0, '-'), 4, 0, '-') AS 전화번호FROM USED_GOODS_USER UJOIN ( SELECT WRITER_ID FROM USED_GOODS_BOARD GROUP BY WRITER_ID HAVING COUNT(*) >= 3) B ON U.USER_ID = B.WRITER_IDORDER BY U.USER_ID DESC; 결과값 잘보고 띄어쓰기도 놓치지 말기..^^

MySQL) 조회수가 가장 많은 중고거래 게시판의 첨부파일 조회하기

SELECT concat('/home/grep/src/', F.BOARD_ID ,'/', F.FILE_ID , F.FILE_NAME , F.FILE_EXT) AS FILE_PATHFROM USED_GOODS_BOARD AS BJOIN USED_GOODS_FILE F ON B.BOARD_ID = F.BOARD_ID WHERE B.VIEWS = (SELECT MAX(VIEWS) FROM USED_GOODS_BOARD B)ORDER BY F.FILE_ID DESC문제를 잘읽자 : 첨부파일 '전체!'를 출력

MySQL) 조건에 부합하는 중고거래 댓글 조회하기

SELECT B.TITLE, B.BOARD_ID, R.REPLY_ID, R.WRITER_ID, R.CONTENTS, DATE_FORMAT(R.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATEFROM USED_GOODS_REPLY AS RLEFT JOIN USED_GOODS_BOARD B ON B.BOARD_ID = R.BOARD_ID WHERE DATE_FORMAT(B.CREATED_DATE, '%Y-%m') = '2022-10'ORDER BY R.CREATED_DATE, B.TITLE

MySQL) 조건에 부합하는 중고거래 상태 조회하기

SELECT B.BOARD_ID, B.WRITER_ID, B.TITLE, B.PRICE, CASE WHEN B.STATUS = 'SALE' THEN '판매중' WHEN B.STATUS = 'RESERVED' THEN '예약중' WHEN B.STATUS = 'DONE' THEN '거래완료' END AS STATUSFROM USED_GOODS_BOARD AS BWHERE DATE_FORMAT(B.CREATED_DATE, '%Y-%m-%d') = '2022-10-05'ORDER BY B.BOARD_ID DESC