SQL - LEVEL 01 문법 정리

def solution(a, b):
    return int(max(f"{a}{b}", f"{b}{a}"))

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


# SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, FREEZER_YN
# FROM FOOD_WAREHOUSE
# WHERE FREEZER_YN IS NOT NULL AND WAREHOUSE_NAME LIKE '%경기%'
# UNION ALL
# SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, 'N'
# FROM FOOD_WAREHOUSE
# WHERE FREEZER_YN IS NULL AND WAREHOUSE_NAME LIKE '%경기%'
# ORDER BY WAREHOUSE_ID

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

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

 

코딩테스트 연습 - 경기도에 위치한 식품창고 목록 출력하기 | 프로그래머스 스쿨 (programmers.co.kr)

프로그래머스

* 쉬운 문제 이지만, 각 다른 풀이법 익히기!