1
2
3
4
5
6
7
8
9
10
11
12
-- 코드를 입력하세요

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