문제 링크 : https://school.programmers.co.kr/learn/courses/30/lessons/59410 정상 코드. 방법 1.COALESCE 사용 SELECT ANIMAL_TYPE, COALESCE(NAME, 'No name') AS NAME, SEX_UPON_INTAKE FROM ANIMAL_INS ORDER BY ANIMAL_ID 방법 2. IFNULL사용 SELECT ANIMAL_TYPE, IFNULL(NAME, 'No name') AS NAME, SEX_UPON_INTAKE FROM ANIMAL_INS ORDER BY ANIMAL_ID 방법 3. CASE표현식 사용 SELECT ANIMAL_TYPE, CASE WHEN NAME IS NULL THEN 'No name' EL..