[SELECT/LEVEL1] 12세 이하인 여자 환자 목록 출력하기 (MySQL /Oracle)

MySQL

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

 

---

Oracle

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;