[SQL] 코딩테스트 연습 Lv4

# 1.식품분류별 가장 비싼 식품의 정보 조회하기
SELECT CATEGORY, PRICE AS MAX_PRICE, PRODUCT_NAME
FROM FOOD_PRODUCT
WHERE PRICE IN (SELECT MAX(PRICE) 
                FROM FOOD_PRODUCT
                GROUP BY CATEGORY)
AND CATEGORY IN ('과자', '국', '김치', '식용유')
ORDER BY PRICE DESC

# 2.취소되지 않은 진료 예약 조회하기
SELECT APNT_NO, PT_NAME, A.PT_NO, D.MCDP_CD, DR_NAME, APNT_YMD
FROM APPOINTMENT A
JOIN PATIENT P ON A.PT_NO = P.PT_NO
JOIN DOCTOR D ON D.DR_ID = A.MDDR_ID
WHERE APNT_YMD LIKE '2022-04-13%'
AND APNT_CNCL_YN = 'N'
AND D.MCDP_CD = 'CS'
ORDER BY APNT_YMD