[SQL / ORACLE] 3월에 태어난 여성 회원 목록 출력하기

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

정말 개판을 짜긴 했다..다른 사람의 코드를 분석해보자.

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

밑에 있는 코드가 더 직관적이고 간결하다.