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

[ji-0630]

문제 설명

[ji-0630]

나의 풀이

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 TLNO is not null
and GENDER = "W"
order by MEMBER_ID