I’m trying to create an internal knowledge sharing system. everyone in the system can post questions, and others can answer, which they can answer the questions through “Related Answers” column generated automatically by the system. I want to add a third layer that users can rate the questions by 1-5, so I created the third data base called Ratings, and people who want to rate can access through related ratings column.
The problem I having right now is, I want to have a column called “Average Ratings”, so I can sort answers by averaging ratings. How can I acquire the average number of “Related Ratings”?