hourly average help

[tommo5]

Please help! im new to SQL and im finding a way of calculating an hourly avg difficult.

This is what i have so far for all the data for the week - but i want an hourly avg instead of every second of everyday between. Please help! thanks


select "computerName" , "TimeSampled", "PerformanceCounterName", "SampledValue"
from dbo.SDKPerformanceview
where computername like 'dmm%' and performancecountername like 'total messages submitted'
and timesampled between '2007-05-14 00:00:00' and '2007-05-20 23:59:00'