Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE player_college ( player_id VARCHAR, college_id VARCHAR )
TABLE: CREATE TABLE player ( height INTEGER, player_id VARCHAR )
TABLE: CREATE TABLE college ( college_id VARCHAR, name_full VARCHAR )

### Question ###
What is the average height of the players from the college named 'Yale University'?

### Accurate SQL ###

SELECT AVG(T1.height) FROM player AS T1 JOIN player_college AS T2 ON T1.player_id = T2.player_id JOIN college AS T3 ON T3.college_id = T2.college_id WHERE T3.name_full = 'Yale University'