문제코드WITH DURATION AS(SELECT HISTORY_ID, CAR_ID, (DATEDIFF(END_DATE, START_DATE)+1)AS DIFFDAY, (CASE WHEN DATEDIFF(END_DATE, START_DATE)+1 >= 90 THEN '90일 이상' WHEN DATEDIFF(END_DATE, START_DATE)+1 >= 30 THEN '30일 이상' WHEN DATEDIFF(END_DATE, START_DATE)+1 >= 7 THEN '7일 이상' ELSE '할인 없음' END) AS DURATION_TYP..

문제코드SELECT IDFROM ECOLI_DATAWHERE PARENT_ID IN(SELECT ID FROM ECOLI_DATA WHERE PARENT_ID IN (SELECT ID FROM ECOLI_DATA WHERE PARENT_ID IS NULL))ORDER BY ID 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/301650

문제코드SELECT HOUR, COUNT(ANIMAL_ID) AS COUNTFROM ( SELECT (ROW_NUMBER() OVER () - 1) AS HOUR FROM ANIMAL_OUTS LIMIT 24) AS 24HOURS_NUM_TABLE LEFT JOIN ANIMAL_OUTS ON HOUR = HOUR(DATETIME)GROUP BY HOURORDER BY HOUR 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/59413

문제코드SELECT DATE_FORMAT(SALES_DATE,'%Y-%m-%d'), PRODUCT_ID, USER_ID, SALES_AMOUNTFROM ( SELECT SALES_DATE, PRODUCT_ID, USER_ID, SALES_AMOUNT FROM ONLINE_SALE WHERE SALES_DATE BETWEEN '2022-03-01' AND '2022-03-31' UNION ALL SELECT SALES_DATE, PRODUCT_ID, NULL AS USER_ID, SALES_AMOUNT FROM OFFLINE_SALE WHERE SALES_DATE BETWEEN '2022-03-01' AND '2022-03-31') AS COMBINED_..

문제코드SELECT MP.MEMBER_NAME, RR.REVIEW_TEXT, DATE_FORMAT(RR.REVIEW_DATE, '%Y-%m-%d') AS REVIEW_DATEFROM MEMBER_PROFILE MP LEFT JOIN REST_REVIEW RR ON MP.MEMBER_ID = RR.MEMBER_IDWHERE RR.MEMBER_ID = (SELECT MEMBER_ID FROM REST_REVIEW GROUP BY MEMBER_ID ORDER BY COUNT(*) DESC LIMIT 1)ORDER BY RR.REVIE..

문제코드SELECT HG.EMP_NO, HE.EMP_NAME, (CASE WHEN AVG(HG.SCORE) >= 96 THEN 'S' WHEN AVG(HG.SCORE) = 90 THEN 'A' WHEN AVG(HG.SCORE) = 80 THEN 'B' ELSE 'C' END) AS GRADE, (CASE WHEN..