SQL124 [프로그래머스 / SQL] 조건에 맞는 사용자와 총 거래금액 조회하기 -CodeSELECT USER_ID, NICKNAME, SUM(PRICE) AS TOTAL_SALESFROM USED_GOODS_BOARD AS UGB JOIN USED_GOODS_USER AS UGU ON UGB.WRITER_ID = UGU.USER_IDWHERE UGB.STATUS = 'DONE'GROUP BY USER_IDHAVING TOTAL_SALES >= 700000ORDER BY SUM(PRICE); 2025. 7. 23. [프로그래머스 / SQL] 오랜 기간 보호한 동물(2) -CodeSELECT AO.ANIMAL_ID, AO.NAMEFROM ANIMAL_INS AS AI INNER JOIN ANIMAL_OUTS AS AO ON AI.ANIMAL_ID = AO.ANIMAL_IDORDER BY DATEDIFF(AO.DATETIME, AI.DATETIME) DESCLIMIT 2; 2025. 7. 23. [프로그래머스 / SQL] 있었는데요 없었습니다 -CodeSELECT AI.ANIMAL_ID, AI.NAMEFROM ANIMAL_INS AS AI JOIN ANIMAL_OUTS AS AO ON AI.ANIMAL_ID = AO.ANIMAL_IDWHERE AI.DATETIME > AO.DATETIMEORDER BY AI.DATETIME; 2025. 7. 22. [프로그래머스 / SQL] 대여 기록이 존재하는 자동차 리스트 구하기 -CodeSELECT DISTINCT CCRH.CAR_IDFROM CAR_RENTAL_COMPANY_CAR AS CCC JOIN CAR_RENTAL_COMPANY_RENTAL_HISTORY AS CCRH ON CCC.CAR_ID = CCRH.CAR_IDWHERE CCC.CAR_TYPE = '세단' AND MONTH(CCRH.START_DATE) = 10ORDER BY CAR_ID DESC; 2025. 7. 22. [프로그래머스 / SQL] 조건별로 분류하여 주문상태 출력하기 -CodeSELECT ORDER_ID, PRODUCT_ID, DATE_FORMAT(OUT_DATE, '%Y-%m-%d') AS OUT_DATE, CASE WHEN OUT_DATE '2022-05-01' THEN '출고대기' ELSE '출고미정' END AS '출고여부'FROM FOOD_ORDERORDER BY ORDER_ID; 2025. 7. 22. [프로그래머스 / SQL] 오랜 기간 보호한 동물(1) -CodeSELECT NAME, DATETIMEFROM ANIMAL_INSWHERE ANIMAL_ID NOT IN ( SELECT ANIMAL_ID FROM ANIMAL_OUTS )ORDER BY DATETIMELIMIT 3; 2025. 7. 21. 이전 1 ··· 6 7 8 9 10 11 12 ··· 21 다음
