[프로그래머스 - ORACLE] 강원도에 위치한 생산공장 목록 출력하기

---

CREATE 문

CREATE TABLE FOOD_FACTORY  (
FACTORY_ID		VARCHAR(10)	NOT NULL,
FACTORY_NAME		VARCHAR(50)	NOT NULL,
ADDRESS			VARCHAR(100)	NOT NULL,
TLNO			VARCHAR(20)	NULL
)

 

---

• 내 풀이

SELECT
    FACTORY_ID,
    FACTORY_NAME,
    ADDRESS
FROM FOOD_FACTORY 
WHERE ADDRESS LIKE '강원도%'
ORDER BY FACTORY_ID ASC;