SET @INDEX_HOUR = -1;SELECT (@INDEX_HOUR := @INDEX_HOUR + 1) AS HOUR, (SELECT COUNT(\*) FROM ANIMAL_OUTS WHERE HOUR(DATETIME) = @INDEX_HOUR) AS
SELECT S1.Score, (SELECT COUNT(DISTINCT Score) FROM Scores WHERE Score >= S1.Score) AS 'Rank'FROM Scores AS S1ORDER BY S1.Score DESC