[프로그래머스 SQL] LV.2 NULL 처리하기

❓ Question

❗ Answer

SELECT animal_type, IFNULL(name,'No name') name, sex_upon_intake
FROM animal_ins
ORDER BY animal_id

📌 Discussion

• IFNULL로 null값은 'No name'으로 대체해 줌