SQL 고득점 Kit - SELECT Level2 - 3월에 태어난 여성 회원 목록 출력하기 - mysql

https://school.programmers.co.kr/learn/challenges?page=1&languages=mysql&order=recent

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

date_format(<DATE 컬럼>, '%Y-%m-%d')

month(<DATE 컬럼>)

year(<DATE 컬럼>)