#107. [LeetCode / MySQL] 180. Consecutive Numbers

문제 입력 코드 1. SELECT DISTINCT a.num AS ConsecutiveNums FROM Logs AS a JOIN Logs AS b ON (a.id = b.id + 1) AND (a.num = b.num) JOIN Logs AS c ON (b.id = c.id + 1) AND (b.num = c.num) 2. WITH cte AS ( SELECT num, LAG(num) OVER (ORDER BY id) AS prev_num, LEAD(num) OVER (ORDER BY id) AS next_num FROM Logs ) SELECT num AS ConsecutiveNums FROM cte WHERE num = prev_num AND num = next_num GROUP BY num; 코드..

• format_list_bulleted SQL
• · 2023. 10. 3.
• textsms

#73. STRING, DATE : 자동차 대여 기록 별 대여 금액 구하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. SELECT RENT.HISTORY_ID, ROUND(CAR.DAILY_FEE * (DATEDIFF(RENT.END_DATE, RENT.START_DATE)+1) * (CASE WHEN DATEDIFF(END_DATE,START_DATE)+1 < 7 THEN 1 WHEN DATEDIFF(END_DATE,START_DATE)+1 < 30 THEN 0.95 WHEN DATEDIFF(END_DATE,START_DATE)+1 < 90 THEN 0.92 ELSE 0.85 END) ) AS FEE FROM CAR_RENTAL_COMPANY_CAR AS CAR JOIN CAR_RENTAL_COMPANY_RENTAL_HISTORY AS RENT ON CAR.CAR_ID = RENT.CAR_ID J..

• format_list_bulleted SQL
• · 2023. 8. 30.
• textsms