SELECT
warehouse_id,
warehouse_name,
address,
ifnull(freezer_yn, "N") as FREEZER_YN
from food_warehouse
where address like '경기도%'
order by warehouse_id asc
SELECT animal_id
from animal_ins
where name is null
order by animal_id asc
SELECT animal_id
from animal_ins
where name is not null
order by animal_id asc
SELECT animal_type, ifnull(name, 'No name'), sex_upon_intake
from animal_ins
order by animal_id asc
SELECT count(*) as USERS
from user_info
where age is null