SELECT ANIMAL_ID, NAME,
CASE SEX_UPON_INTAKE
WHEN 'Neutered MALE' THEN 'O'
WHEN 'Spayed FEMALE' THEN 'O'
ELSE 'X'
END
FROM ANIMAL_INS
ORDER BY ANIMAL_ID
코드 - DATE_FORMAT, COUNT, WHERE, BETWEEN A AND B, GROUP BY, ORDER BY
SELECT DATE_FORMAT(DATETIME, "%H"), COUNT(ANIMAL_ID)
FROM ANIMAL_OUTS
WHERE DATE_FORMAT(DATETIME, "%H") BETWEEN 9 AND 20
GROUP BY DATE_FORMAT(DATETIME, "%H")
ORDER BY DATE_FORMAT(DATETIME, "%H")