>Thanks. I tried this. The name of my table is in fact ratings
>
>

>select [hour], avg(mRating) as AvgRating from Ratings GROUP BY [hour]
>

>
>But I don't get an average for every hour, instead I got an average for the entire table, in other words a table with a single record?
>
>

>exp_1     AvgRating
>hour       3.64
>

>
>Have any ideas?
>Thanks
>Steve

Where did you run the query and what is the exact query you ran? The query above should have given you a row for every hour. BTW, it is always better to avoid reserved words as column names as in this case you have to put the column name in brackets.