1. quiz
- 12세 여아의 데이터 추출
2. answer
SELECT PT_NAME, PT_NO, GEND_CD, AGE, COALESCE(tlno, 'NONE') AS TLNO
FROM patient
WHERE age <=12 AND GEND_CD = 'W'
ORDER BY age DESC, pt_name
To be a changer who can overturn world
SELECT PT_NAME, PT_NO, GEND_CD, AGE, COALESCE(tlno, 'NONE') AS TLNO
FROM patient
WHERE age <=12 AND GEND_CD = 'W'
ORDER BY age DESC, pt_name