I have a database AfricanRatings on which I used the query
INSERT INTO AfricanRatingsAVG SELECT RecipeID, Count(*) AS cnt, AVG(Rating) FROM AfricanRatings GROUP BY RecipeID ORDER BY RecipeID
to get the average rating per recipe and the total count per recipeID. The average and the count were placed into a table AfricanRatingsAVG via the query. On the initial query, AfricanRatingsAVG is updated but not with subsequent ratings. I have tried all sorts of UPDATES to get the AfricanRatingAVG table to update every time a new rating is added to the AfricanRatings table, however, no update occurs. Any guidance in the right direction would be appreciated.