44. 가격대 별 상품 개수 구하기
SELECT CASE WHEN PRICE<10000 THEN 0
WHEN PRICE<20000 THEN 10000
WHEN PRICE<30000 THEN 20000
WHEN PRICE<40000 THEN 30000
WHEN PRICE<50000 THEN 40000
WHEN PRICE<60000 THEN 50000
WHEN PRICE<70000 THEN 60000
WHEN PRICE<80000 THEN 70000
WHEN PRICE<90000 THEN 80000
ELSE NULL END PRICE_GROUP,
COUNT(PRODUCT_ID) PRODUCTS
FROM PRODUCT
GROUP BY 1
ORDER BY 1
45. 3월에 태어난 여성 회원 목록 출력하기
SELECT MEMBER_ID, MEMBER_NAME, GENDER,
DATE_FORMAT(DATE_OF_BIRTH, '%Y-%m-%d') DATE_OF_BIRTH
FROM MEMBER_PROFILE
WHERE DATE_OF_BIRTH LIKE '%-03-%'
AND TLNO IS NOT NULL
AND GENDER = 'W'
ORDER BY MEMBER_ID