SELECT animal_id, name, sex_upon_intake
from animal_ins
where
sex_upon_intake like 'Spayed%' and
name in ('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty')
order by animal_id
SELECT animal_id, name
from animal_ins
where lower(name) like '%el%' and animal_type = 'Dog'
order by name asc
SELECT animal_id, name,
case when (sex_upon_intake like 'Neutered%') then 'O'
when (sex_upon_intake like 'Spayed%') then 'O'
else 'X'
end as 중성화
from animal_ins
order by animal_id
SELECT substring(product_code, 1, 2) as CATEGORY, count(*) as PRODUCTS
from product
group by CATEGORY
order by CATEGORY asc
SELECT animal_id, name, date_format(datetime, '%Y-%m-%d') as '날짜'
from animal_ins
order by animal_id;