SQL：在多个选定的表上使用AVG函数，但仅针对一列，并按该列分组

I am trying to run an SQL query. I've joined multiple tables using the JOIN function so that I have all the data I need in columns (and only those I need).I am trying to run an SQL query. I've joined mu