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

SQL을 실행하면 다음과 같이 출력되어야 합니다.

MEMBER_ID / MEMBER_NAME / GENDER / DATE_OF_BIRTH

seoyeons@naver.com

박서연

W

1993-03-16

 

예시

MEMBER_PROFILE 테이블이 다음과 같을 때

MEMBER_ID / MEMBER_NAME / TLNO / GENDER / DATE_OF_BIRTH

jiho92@naver.com	이지호	01076432111	W	1992-02-12
jiyoon22@hotmail.com	김지윤	01032324117	W	1992-02-22
jihoon93@hanmail.net	김지훈	01023258688	M	1993-02-23
seoyeons@naver.com	박서연	01076482209	W	1993-03-16
yoonsy94@gmail.com	윤서연	NULL	W	1994-03-19

 

바뀐 코드

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;

 

원래 코드

 

SELECT MEMBER_ID, MEMBER_NAME, GENDER, DATE_OF_BIRTH
FROM MEMBER_PROFILE
WHERE MONTH(DATE_OF_BIRTH) = 3 AND GENDER = 'W' AND TLNO IS NOT NULL
ORDER BY MEMBER_ID;