๋ฌธ์ ํ์ด ๊ธฐ๊ฐ : 24๋ 12์ 27์ผ ~ ์ต์ ์์ผ๋ก ์ ๋ ฌํ ๋ฌธ์ ์์์ ๋๋ค ๋ณดํธ์์์ ์ค์ฑํํ ๋๋ฌผSELECT I.ANIMAL_ID , I.ANIMAL_TYPE , I.NAMEFROM ANIMAL_INS AS I JOIN ANIMAL_OUTS AS O ON I.ANIMAL_ID = O.ANIMAL_IDWHERE SEX_UPON_INTAKE REGEXP 'Intact' AND SEX_UPON_OUTCOME REGEXP 'Spayed|Neutered'ORDER BY ANIMAL_ID ์ ์ ์๊ฐ ๊ตฌํ๊ธฐ(2)WITH RECURSIVE CTE_HOUR AS ( SELECT 0 AS HOUR UNION ALL SELECT HOUR + 1 FROM CTE_..
