I have 1 minutes of data for entire day. I want the average of the 1 hour in a bar-chart.
For example
Calculate the average from 1:00 to 2:00 and show the average for the data in a bar graph format.
Time data AVG for data (EXAMPLE)
2022-01-26 1:00:00. 5.00 6.0
2022-01-26 1:01:00. 5.90 6.0
......
2022-01-26 2:00:00 9.11 6.0
Need the query please