1. 3월에 태어난 여성 회원 목록 출력하기
SELECT MEMBER_ID, MEMBER_NAME, GENDER, date_format(DATE_OF_BIRTH,'%Y-%m-%d')
FROM MEMBER_PROFILE
WHERE TLNO IS NOT NULL
AND gender = "W"
AND DATE_OF_BIRTH LIKE "%-03-%"
ORDER BY MEMBER_ID ASC;
2. 흉부외과 또는 일반외과 의사 목록 출력하기
SELECT dr_name, dr_id, mcdp_cd, date_format(hire_ymd,'%Y-%m-%d') AS hire_ymd
FROM doctor
WHERE mcdp_cd = 'CS'
OR mcdp_cd = 'GS'
ORDER BY hire_ymd DESC, dr_name ASC;
Share article