프로그래머스 SQL 문제풀이(Oracle)/SQL LV2(Oracle)
3월에 태어난 여성 회원 목록 출력하기
빛하루
2023. 9. 2. 17:02
SELECT MEMBER_ID, MEMBER_NAME, GENDER,
to_char(DATE_OF_BIRTH,'YYYY-MM-DD') AS DATE_OF_BIRTH
FROM MEMBER_PROFILE
WHERE to_char(DATE_OF_BIRTH,'YYYY-MM-DD') LIKE '_____03___'
AND
GENDER = 'W'
AND
TLNO IS NOT NULL
ORDER BY MEMBER_ID;