I have a basic table in MySQL
Timestamp - datetime
Value - double
I have data for every minute stored in this table, for example:
1/1/2014 12:02:00 ....
I'd like to write a query that will return the average 'Value' of each hour, for the past 60 hours.
Any suggestions on the best approach?