[SQL] 3월에 태어난 여성 회원 목록 출력하기 (MySQL)

문제

 

풀이과정

날짜 포맷 맞추는 과정을 고려할 것

 

Script

SELECT MEMBER_ID,
        MEMBER_NAME,
        GENDER,
        DATE_FORMAT(DATE_OF_BIRTH, '%Y-%m-%d') AS DATE_OF_BIRTH
FROM MEMBER_PROFILE

WHERE 
    SUBSTRING_INDEX(SUBSTRING_INDEX(DATE_OF_BIRTH, '-', 2),'-',-1) =03
    AND GENDER ='W'
    AND TLNO IS NOT NULL
ORDER BY MEMBER_ID ASC;

이렇게 풀었지만 날짜 조건이 깔끔하지 않아 다른분 쿼리를 참고함.

 

다른 풀이

SELECT MEMBER_ID,
        MEMBER_NAME,
        GENDER,
        DATE_FORMAT(DATE_OF_BIRTH, '%Y-%m-%d') AS DATE_OF_BIRTH
FROM MEMBER_PROFILE

WHERE 
    MONTH(DATE_OF_BIRTH) = 3
    AND GENDER ='W'
    AND TLNO IS NOT NULL
ORDER BY MEMBER_ID ASC;