#75. [LeetCode / MySQL] 1757. Recyclable and Low Fat Products

문제 입력 코드 SELECT product_id FROM Products WHERE low_fats = 'Y' AND recyclable = 'Y' 코드 설명 #SELECT #WHERE #AND 문제 출처 Recyclable and Low Fat Products - LeetCode Can you solve this real interview question? Recyclable and Low Fat Products - Table: Products +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | low_fats | enum | | recyclable | enum | +-------..

• format_list_bulleted SQL
• · 2023. 9. 1.
• textsms

#74. JOIN : 상품을 구매한 회원 비율 구하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. SELECT YEAR, MONTH, COUNT(*) AS PUCHASED_USERS, ROUND((COUNT(*)/ ( SELECT COUNT(*) FROM USER_INFO WHERE YEAR(JOINED) = 2021 )), 1) AS PUCHASED_RATIO FROM ( SELECT DISTINCT YEAR(S.SALES_DATE) AS YEAR, MONTH(S.SALES_DATE) AS MONTH, U.USER_ID FROM ONLINE_SALE AS S JOIN USER_INFO AS U ON S.USER_ID = U.USER_ID AND YEAR(JOINED) = 2021 ) AS A GROUP BY YEAR, MONTH ORDER BY YEAR, MONTH; 2. SE..

• format_list_bulleted SQL
• · 2023. 8. 31.
• 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

#72. STRING, DATE : 취소되지 않은 진료 예약 조회하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 SELECT A.APNT_NO, P.PT_NAME, P.PT_NO, A.MCDP_CD, D.DR_NAME, A.APNT_YMD FROM APPOINTMENT AS A JOIN PATIENT AS P ON A.PT_NO = P.PT_NO JOIN DOCTOR AS D ON A.MDDR_ID = D.DR_ID WHERE DATE_FORMAT(A.APNT_YMD, '%Y-%m-%d') = '2022-04-13' AND A.APNT_CNCL_YN = 'N' AND A.MCDP_CD = 'CS' ORDER BY A.APNT_YMD ASC; 코드 설명 #SELECT #JOIN #WHERE #DATE_FORMAT #AND #ORDER BY 문제 출처 https://school.programmers.c..

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

MySQL 예약어

MySQL 예약어 ADD ALL ALTER ANALYZE AND AS ASC ASENSITIVE BEFORE BETWEEN BIGINT BINARY BLOB BOTH BY CALL CASCADE CASE CHANGE CHAR CHARACTER CHECK COLLATE COLUMN CONDITION CONSTRAINT CONTINUE CONVERT CREATE CROSS CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR DATABASE DATABASES DAY_HOUR DAY_MICROSECOND DAY_MINUTE DAY_SECOND DEC DECIMAL DECLARE DEFAULT DELAYED DELETE DESC DESCRIBE DET..

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

#71. JOIN : 보호소에서 중성화한 동물 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. SELECT I.ANIMAL_ID, I.ANIMAL_TYPE, I.NAME FROM ANIMAL_INS AS I JOIN ANIMAL_OUTS AS O ON I.ANIMAL_ID = O.ANIMAL_ID WHERE I.SEX_UPON_INTAKE LIKE 'Intact%' AND (O.SEX_UPON_OUTCOME LIKE 'Spayed%' OR O.SEX_UPON_OUTCOME LIKE 'Neutered%') ORDER BY ANIMAL_ID; 2. SELECT I.ANIMAL_ID, I.ANIMAL_TYPE, I.NAME FROM ANIMAL_INS AS I JOIN ANIMAL_OUTS AS O WHERE (I.ANIMAL_ID = O.ANIMAL_ID) AND (I.SEX_U..

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