Programmers_MySQL

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

콩유니 2024. 2. 6. 11:00

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