문제코드SELECT 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 SUM(PRICE) >= 700000ORDER BY TOTAL_SALES; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/164668

문제코드SELECT AO.ANIMAL_ID, AO.NAMEFROM ANIMAL_INS AS AI JOIN ANIMAL_OUTS AS AO ON AI.ANIMAL_ID = AO.ANIMAL_IDORDER BY AO.DATETIME - AI.DATETIME DESCLIMIT 2; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/59411

문제코드SELECT 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; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/59043

문제코드SELECT DISTINCT CC.CAR_IDFROM CAR_RENTAL_COMPANY_CAR AS CC JOIN CAR_RENTAL_COMPANY_RENTAL_HISTORY AS CH ON CC.CAR_ID = CH.CAR_IDWHERE CC.CAR_TYPE = '세단' AND MONTH(CH.START_DATE) = 10ORDER BY CC.CAR_ID DESC; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/157341

문제코드SELECT BOOK.CATEGORY, SUM(SALES) AS 'TOTAL_SALES'FROM BOOK JOIN BOOK_SALES ON BOOK.BOOK_ID = BOOK_SALES.BOOK_IDWHERE DATE_FORMAT(BOOK_SALES.SALES_DATE, '%Y-%m') = '2022-01'GROUP BY BOOK.CATEGORYORDER BY BOOK.CATEGORY; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/144855

문제코드SELECT ORDER_ID, PRODUCT_ID, DATE_FORMAT(OUT_DATE, '%Y-%m-%d'), (CASE WHEN ISNULL(OUT_DATE) THEN '출고미정' WHEN '2022-05-01' = OUT_DATE THEN '출고완료' END) AS 출고여부FROM FOOD_ORDERORDER BY ORDER_ID; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/131113