[프로그래머스_sql] Python 개발자 찾기

- 문제

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

 

- 해결

-- 코드를 입력하세요
SELECT PT_NAME,PT_NO,GEND_CD,AGE,coalesce(TLNO,'NONE') AS TLNO
FROM PATIENT 
WHERE AGE <= 12
AND GEND_CD = "W"
-- GROUP BY PT_NAME
ORDER BY AGE DESC, PT_NAME

 

- 생각 

 X