Lv2. NULL처리하기

▶ 문제

 

▶ 풀이방법

- 첫번째 풀이방법(CASE WHEN 사용)

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

 

- 두번째 풀이방법( IFNULL() )

SELECT ANIMAL_TYPE, IFNULL(NAME, "No name"), SEX_UPON_INTAKE
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;