[MySQL/프로그래머스]경기도에 위치한 식품창고 목록 출력하기

https://school.programmers.co.kr/learn/courses/30/lessons/131114

SELECT WAREHOUSE_ID,
        WAREHOUSE_NAME,
        ADDRESS,
        CASE 
            WHEN FREEZER_YN IS NULL THEN 'N'
            ELSE FREEZER_YN
        END AS FREEZER_YN
FROM FOOD_WAREHOUSE
WHERE ADDRESS LIKE '경기도%'
ORDER BY WAREHOUSE_ID;

• IFNULL을 활용한 더 짧은 코드

SELECT WAREHOUSE_ID,
        WAREHOUSE_NAME,
        ADDRESS,
        IFNULL(FREEZER_YN,'N') AS FREEZER_YN
FROM FOOD_WAREHOUSE
WHERE ADDRESS LIKE '경기도%'
ORDER BY WAREHOUSE_ID;