search for: contest_entries

Hi there, I''m trying to grab all the contest_entries from a particular contest, and then grab all the appropriate contest_ratings associated with the songs and contest. The end result is an average score for each song involved in each contest. I made an ERD of my table structure which can be found at: http://antrover.com/erd/contest_question.jpg He...