[프로그래머스][MYSQL][Level 2][59410] NULL 처리하기

1
2
3
4
5
6

SELECT 
    ANIMAL_TYPE, 
    CASE WHEN NAME IS NULL THEN "No name" ELSE NAME END,
    SEX_UPON_INTAKE
FROM 
    ANIMAL_INS

1
2
3
4

SELECT
    ANIMAL_TYPE, IFNULL(NAME,'No name') AS NAME, SEX_UPON_INTAKE
FROM
    ANIMAL_INS

1
2
3
4
5
6
7
8

SELECT 
    ANIMAL_TYPE, 
    CASE WHEN NAME IS NULL THEN "No name" ELSE NAME END,
    SEX_UPON_INTAKE
FROM 
    ANIMAL_INS
ORDER BY
    ANIMAL_ID