SQL 20241005

20241005===========================================

# Lv 1. 조건에 맞는 도서 리스트 출력하기

SELECT BOOK_ID, DATE_FORMAT(PUBLISHED_DATE,"%Y-%m-%d") AS PUBLISHED_DATE
FROM BOOK
WHERE CATEGORY = '인문'
AND (PUBLISHED_DATE BETWEEN '2021-01-01' AND '2021-12-31')
ORDER BY BOOK_ID,PUBLISHED_DATE;

# Lv 2. 3월에 태어난 여성 회원 목록 출력하기

SELECT MEMBER_ID, MEMBER_NAME, GENDER, DATE_FORMAT(DATE_OF_BIRTH,'%Y-%m-%d') AS DATE_OF_BIRTH
FROM MEMBER_PROFILE
WHERE DATE_FORMAT(DATE_OF_BIRTH,'%m') = '03'
AND TLNO IS NOT NULL AND GENDER = 'W'
ORDER BY MEMBER_ID;

# Lv 4. 식품분류별 가장 비싼 식품의 정보 조회하기
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 MAX_PRICE DESC;