SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE
FROM ANIMAL_INS
WHERE NAME IN ('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty')
LIKE
와 %
를 이용하여 문자열을 필터링 할 수 있다.
SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE LOWER(NAME) LIKE '%el%'
AND ANIMAL_TYPE = 'Dog'
ORDER BY NAME
SELECT
ANIMAL_ID,
NAME,
CASE WHEN SEX_UPON_INTAKE LIKE '%Neutered%' THEN 'O'
WHEN SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O'
ELSE 'X'
END '중성화'
FROM ANIMAL_INS
ORDER BY ANIMAL_ID
SELECT A_IN.ANIMAL_ID, A_IN.NAME
FROM ANIMAL_INS A_IN INNER JOIN ANIMAL_OUTS A_OUT
ON A_IN.ANIMAL_ID = A_OUT.ANIMAL_ID
ORDER BY A_OUT.DATETIME - A_IN.DATETIME DESC
LIMIT 2
SELECT ANIMAL_ID, NAME, DATE_FORMAT(DATETIME, '%Y-%m-%d') AS '날짜'
FROM ANIMAL_INS