How to make a MySQL query grouped by timestamp every 60 minutes?

Question

MySQL

There is a database in which monitoring data is added every minute, including the time in timestamp.
It is necessary to make a request with minimum, maximum data for a period of time, for example, every 5, 15, 60 minutes.
That is, you need to look at the maximum value of some parameter in the period from January 1 to January 31, with a period of one hour.
Here is an example query: SELECT min(sum), max(sum) FROM info WHERE time > 0 AND time < 2592000
GROUP BY suggests itself, but how can I set the interval for the timestamp?

Answer 1

GROUP BY FLOOR(`time` / 3600)