[프로그래머스] 취소되지 않은 진료 예약 조회하기

문제

제출

SELECT b.apnt_no,a.pt_name,a.pt_no,b.mcdp_cd,c.dr_name,b.apnt_ymd
from patient as a
join appointment as b
join doctor as c
on a.pt_no = b.pt_no and b.mddr_id = c.dr_id
where date_format(b.apnt_ymd,'%Y-%m-%d')='2022-04-13' and b.apnt_cncl_yn='N' and b.mcdp_cd='CS'
order by 6 asc

또 다른 답

SELECT b.apnt_no,a.pt_name,a.pt_no,b.mcdp_cd,c.dr_name,b.apnt_ymd
from patient as a
join appointment as b
on a.pt_no = b.pt_no
join doctor as c
on b.mddr_id = c.dr_id
where date_format(b.apnt_ymd,'%Y-%m-%d')='2022-04-13' and b.apnt_cncl_yn='N' and b.mcdp_cd='CS'
order by 6 asc

on 조건을 명확히 작성

SELECT b.apnt_no,a.pt_name,a.pt_no,b.mcdp_cd,c.dr_name,b.apnt_ymd
from patient as a
join appointment as b
on a.pt_no = b.pt_no
join doctor as c
on b.mddr_id = c.dr_id
where date(b.apnt_ymd)='2022-04-13' and b.apnt_cncl_yn='N' and b.mcdp_cd='CS'
order by 6 asc

date(b.apnt_ymd)='2022-04-13'
DATE(b.apnt_ymd) 를 쓰면 시간 부분을 제거하고 ‘YYYY-MM-DD’ 형식으로 변환됨.