Hi! I’m making this mini web community where members can log in and share recipes. They can also give scores to each others recipes. Now, I’m trying to write some sql to find an unweighted average of a member’s scores.
What I’ve got so far is:
SELECT AVG( Score ) AS Score
FROM tblScore s, tblRecipes o
WHERE s.RecipeID = o.RecipeID
AND o.MemberID =1
GROUP BY s.RecipeID
This gives me one row for each of the recipes to a given member. Now I’m trying to find the average of these rows - the average of the result - but I don’t know how to do it.
Any suggestions?
