String, Date
1. 루시와 엘라 찾기
SELECT ANIMAL_ID,NAME,SEX_UPON_INTAKE
FROM ANIMAL_INS
WHERE NAME IN ('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty')
ORDER BY ANIMAL_ID
SELECT ANIMAL_ID,NAME
FROM ANIMAL_INS
WHERE NAME LIKE '%EL%' AND ANIMAL_TYPE='Dog'
ORDER BY NAME;
SELECT ANIMAL_ID,NAME, IF((SEX_UPON_INTAKE LIKE 'Neutered%' OR SEX_UPON_INTAKE LIKE 'Spayed%'),'O','X') as 중성화
FROM ANIMAL_INS
ORDER BY ANIMAL_ID
SELECT animal_id, name,
case
when sex_upon_intake like'Neutered%' or sex_upon_intake like 'Spayed%'
then 'O'
else 'X'
end as 중성화
from animal_ins
order by animal_id
SELECT ai.ANIMAL_ID,ai.NAME
FROM ANIMAL_INS ai
LEFT JOIN ANIMAL_OUTS ao
ON ai.ANIMAL_ID=ao.ANIMAL_ID
ORDER BY DATEDIFF(ao.DATETIME,ai.DATETIME) DESC
LIMIT 2
SELECT animal_id, name, date_format(datetime, '%Y-%m-%d') AS '날짜'
FROM animal_ins
ORDER BY animal_id;