SQL_프로그래머스_3월에 태어난 여성 회원 목록 출력하기
SQL_프로그래머스_3월에 태어난 여성 회원 목록 출력하기 풀이 -- MYSQL 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 ASC; -- ORACLE SELECT MEMBER_ID , MEMBER_NAME , GENDER , TO_CHAR(DATE_OF_BIRTH, 'YYYY-MM-DD') AS DATE_OF_BIRTH FROM MEMBER_PROFILE WHERE GENDER = 'W' AND TLNO IS NOT NULL AND TO_CHAR(DATE_OF_BIRTH, 'MM') = '03' ORDER BY MEMBER_ID ASC;