📌[SQL 문제 풀이] Programmers - 3월에 태어난 여성 회원 목록 출력하기

💻 문제

✍️ 정답

SELECT MEMBER_ID, MEMBER_NAME, GENDER, DATE_FORMAT(DATE_OF_BIRTH, '%Y-%m-%d') as DATE_OF_BIRTH
FROM MEMBER_PROFILE 
WHERE GENDER = "W" and TLNO IS NOT NULL and DATE_FORMAT(DATE_OF_BIRTH,'%m') = '03'
ORDER BY MEMBER_ID
;