[programmers] 경기도에 위치한 식품창고 목록 출력하기

SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, FREEZER_YN,
	CASE
    	WHEN FREEZER_YN IS NULL THEN 'N'
        ELSE FREEZER_YN
    END AS FREEZER_YN
FROM FOOD_WAREHOUSE
ORDER BY WAREHOUSE_ID ASC;

이렇게 했는데 안바꼈다.

SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS,
       CASE
           WHEN UPPER(FREEZER_YN) IS NULL THEN 'N'
           ELSE UPPER(FREEZER_YN)
       END AS FREEZER_YN
FROM FOOD_WAREHOUSE
ORDER BY WAREHOUSE_ID ASC;

맞게 나온 것 같은데 틀렸다.

봤더니 경기도 필터링이었다. 문제를 잘 읽자.

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