모각코 5주차 sql1

https://school.programmers.co.kr/learn/courses/30/lessons/144853

프로그래머스

-- 코드를 입력하세요
SELECT Book_id, DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d')
from book
where category = '인문'
and year(published_date) = 2021
order by published_date asc;

 

 

 

 

https://school.programmers.co.kr/learn/courses/30/lessons/132201

프로그래머스

 

-- 코드를 입력하세요
SELECT PT_NAME, PT_NO, GEND_CD, AGE, 
    case when tlno is null then 'NONE' else tlno end as TLNO
from patient
where age <= 12
and gend_cd = "W"
order by age desc, pt_name asc;