On Wednesday 27 December 2006 17:12, Ashley M. Kirchner wrote:
> Chris Comparini wrote:
> > Try something like this:
> >
> > select hour(time) as the_hour, avg(temp_f) as average_temp_f
> > from data
> > where time > now() - interval 24 hour
> > group by the_hour;
>
> Thanks Chris. Questi
Chris Comparini wrote:
Try something like this:
select hour(time) as the_hour, avg(temp_f) as average_temp_f
from data
where time > now() - interval 24 hour
group by the_hour;
Thanks Chris. Question though, why is it that when I change that to
48 hours, it only gives me 24 results (s