[프로그래머스 - ORACLE] 12세 이하인 여자 환자 목록 출력하기

---

CREATE 문

CREATE TABLE PATIENT (
PT_NO		VARCHAR(10)	NOT NULL,
PT_NAME		VARCHAR(20)	NOT NULL,
GEND_CD		VARCHAR(1)	NOT NULL,
AGE		NUMBER		NOT NULL,
TLNO		VARCHAR(50)	NULL
)

 

---

• 내 풀이

SELECT
    PT_NAME,
    PT_NO,
    GEND_CD,
    AGE,
    NVL(TLNO , 'NONE') AS TLNO
FROM PATIENT 
WHERE AGE <= 12
AND GEND_CD = 'W'
ORDER BY AGE DESC , PT_NAME ASC;