What is the highest average monthly rental of all the students?
select monthly_rental from student_addresses as t1 join students as t2 on t1.student_id = t2.student_id group by t1.student_id order by avg ( monthly_rental ) desc limit 1
Hmm, can you tell me the addresses that have the highest average monthly rental?
select t2.address_id from student_addresses as t1 join students as t2 on t1.student_id = t2.student_id group by t1.student_id order by avg ( monthly_rental ) desc limit 1
What are the id and first name of the student whose addresses have the highest average monthly rental?
select t1.student_id, t2.first_name from student_addresses as t1 join students as t2 on t1.student_id = t2.student_id group by t1.student_id order by avg ( monthly_rental ) desc limit 1