본문 바로가기

Programmers_MySQL

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

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