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

https://school.programmers.co.kr/learn/courses/30/lessons/131120

• 문제 풀이

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, 'MM') = '03'  AND TLNO IS NOT NULL AND GENDER = 'W'
ORDER BY MEMBER_ID;

-- Oracle에서는 EXTRACT 함수를 사용하여 날짜의 일부를 추출할 수 있다.
SELECT 
	MEMBER_ID,
  MEMBER_NAME,
  GENDER,
  TO_CHAR(DATE_OF_BIRTH, 'YYYY-MM-DD') AS "DATE_OF_BIRTH"
FROM 
	MEMBER_PROFILE
WHERE
    GENDER = 'W'
    AND EXTRACT(MONTH FROM DATE_OF_BIRTH) = 3
    AND TLNO IS NOT NULL
ORDER BY
    MEMBER_ID;

• 실행 결과