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

---

CREATE 문

CREATE TABLE FOOD_WAREHOUSE (
WAREHOUSE_ID			VARCHAR(10)	NOT NULL,
WAREHOUSE_NAME			VARCHAR(20)	NOT NULL,
ADDRESS				VARCHAR(100)	NULL,
TLNO				VARCHAR(20)	NULL,
FREEZER_YN			VARCHAR(1)	NULL
)

 

---

• 내 풀이

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