[프로그래머스, 132201] 12세 이하인 여자 환자 목록 출력하기 (mysql)

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

프로그래머스

728x90

---

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