Average with condition from another table

Hello, I have spent all day trying various solutions to this and still can't get anything to work.  If there is another post with a solution already, please point me to it.   I've got two tables (...