Topic: Daily Averages per Month

[_spaz]

How does one get the daily averages per month from a bunch of data with titles and Durations on different dates?

Example:
date              Title      Duration
2010-02-01      1           10
2010-02-03      2           16
2010-02-01      3            24
2010-03-02       4           10
2010-03-08       5           10
etc...


I have this so far but its not calculating the daily average by Month properly

Select Month(`date`) as Month,
avg(`duration`) AS 'Daily Duration'
from Table
where `date` between '2009-01-01' and '2009-12-31'
group by Month

[JustLikeIcarus]

Try one of these.  I think you want the second one
For Monthly Averages

Code: [Select]

Select Month(`date`),  avg(`duration`) AS 'Daily Duration'
from Table
where `date` between '2009-01-01' and '2009-12-31'
group by Month(`date`)
For Daily averages

Code: [Select]

Select Month(`date`), Day(`date`), avg(`duration`) AS 'Daily Duration'
from Table
where `date` between '2009-01-01' and '2009-12-31'
group by Month(`date`), Day(`date`)