mysql averages

[c_pattle]

This may be hard to explain so bear with me.  I have a table called "ratings" which has lots of different ratings in it for different images.  The structure for this table is "picture number", "rating id", "rating".  What I want to achieve is to get a data set from the table of the top 3 rated pictures. 

 

However to do this I'm going to first have to take an average of all of the ratings for each picture.  I was just wondering what the best way to do this is. 

 

Thanks for any help. 

[c_pattle]

Forget that.  At the moment I have this which seems to work.  However this gives me the results with the lowest first.  How can I change that to make it the highest first?

 

select article_number, avg(score) from ratings group by article_number order by avg(score);

 

 

[petroz]

This should work.

SELECT DISTINCT(image_id), AVG(rating) FROM `image_ratings` GROUP BY `image_id` ORDER BY AVG(rating) DESC LIMIT 3 

 

[petroz]

Just set your ORDER BY to DESC.