help!

[Jamie Burns]

hi...

i have a table as follows:

    ref                    smallint(5)
    product_ref        smallint(5)
    rating                smallint(1)

is there any way i can get the average rating for each product_ref?

for example...

   ref    p_ref    rating
    1        1        4
    2        1        5
    3        1        3
    4        1        5
    5        2        4
    6        2        5
    7        3        3
    8        3        2

so that i could find out that:

    product_ref 1, has an average rating of 4.25
    product_ref 2, has an average rating of 4.5
    product_ref 3, has an average rating of 2.5

and could i possibly return the 10 highest rows?

any help with this would be really appreciated...

jamie burns.