SQL 공부
[프로그래머스] SELECT: 3월에 태어난 여성 회원 목록 출력하기
지식보부상님
2025. 1. 14. 15:59
제출 코드
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