코딩테스트 연습(Level.1) / MySQL

풀이 입력

SELECT WAREHOUSE_ID,WAREHOUSE_NAME,ADDRESS,
ifnull(freezer_yn, "N") as FREEZER_YN FROM FOOD_WAREHOUSE
where ADDRESS like "경기도%"
order by WAREHOUSE_ID;

풀이 입력

SELECT ANIMAL_ID,NAME,DATETIME From ANIMAL_INS
order by name, DATETIME desc;

풀이 입력

SELECT FLAVOR from FIRST_HALF
order by TOTAL_ORDER desc, SHIPMENT_ID asc;

풀이 입력

SELECT FACTORY_ID,FACTORY_NAME,ADDRESS From FOOD_FACTORY
where ADDRESS like "강원%"
order by FACTORY_ID;