MySQL使用其他列的数据计算平均值填充列

I have two tables: one is a name and the other is ratings connected by a nameID. I would like to find the average of the ratings from the data in the ratings table and populate that result to the corresponding venue on the venue table. I am not sure how to proceed. Any pointers on how to do this with MySQL?I have two tables: one is a name and the other