プログラマSQL:GROUP BY

SELECT ANIMAL_TYPE,COUNT(*) FROM ANIMAL_INS
GROUP BY ANIMAL_TYPE ORDER BY ANIMAL_TYPE;

SELECT NAME, COUNT(NAME) FROM ANIMAL_INS
GROUP BY NAME HAVING COUNT(NAME)>1 ORDER BY NAME;

SELECT HOUR(DATETIME) "HOUR",COUNT(*) "COUNT" FROM ANIMAL_OUTS
GROUP BY HOUR(DATETIME) HAVING HOUR BETWEEN 9 AND 20
ORDER BY HOUR(DATETIME);

SET @HOUR := -1;    -- =(비교연산자)와 차별하기 위한 :=(대입연산자)
SELECT (@HOUR:=@HOUR+1) "HOUR",
(SELECT COUNT(*) FROM ANIMAL_OUTS WHERE HOUR(DATETIME) = @HOUR) "COUNT"
FROM ANIMAL_OUTS WHERE @HOUR<23;