[코테] 프로그래머스 SQL 고득점 Kit - SELECT 1번

❇️ SELECT

• 💡 조회
  • select 열 from 테이블 where 조건 order by asc / desc;
    
    
• 💡 조건 (new)
  • 다중 : where (조건1) and (조건2)
  • 문자열 : where 열 like '문자'
    • where 열 like '____03___'
    • where 열 like '%사원'
  • 널 제외 : where 열 is not null
    
    
• 💡 날짜 변환 (new)
  • select 열1, 열2, date_format(날짜열, '%Y-%m-%d') as 날짜열 from 테이블

1. SELECT 1번

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

---

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