[IS NULL/LEVEL1] 경기도에 위치한 식품창고 목록 출력하기 (MySQL/Oracle)

MySQL

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

 

---

Oracle

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