[SQL문제풀기] 3월에 태어난 여성 회원 목록 출력하기

문제

MYSQL

내가 작성한 정답

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

ORACLE

내가 작성한 정답

SELECT MEMBER_ID, MEMBER_NAME, GENDER, TO_CHAR(DATE_OF_BIRTH,'YYYY-MM-DD') DATE_OF_BIRTH
FROM MEMBER_PROFILE 
WHERE TO_CHAR(DATE_OF_BIRTH,'MM') = '03' 
    AND GENDER = 'W'
    AND TLNO IS NOT NULL
ORDER BY 1;