Medidata Solutions interview question

Averages and Joins in SQL