# SQL problem

**URL:** <https://forum.kirupa.com/t/sql-problem/234619>\
**Category:** programming\
**Created:** [August 3, 2007, 7:54pm UTC](https://forum.kirupa.com/t/sql-problem/234619 "2007-08-03T19:54:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![magnusvs](https://avatars.discourse-cdn.com/v4/letter/m/c0e974/32.png) [@magnusvs](https://forum.kirupa.com/u/magnusvs)\
**Post date:** [August 3, 2007, 7:54pm UTC](https://forum.kirupa.com/t/sql-problem/234619/1 "2007-08-03T19:54:50Z")

</div>

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?🙂