What's the highest monthly rental in the table Student Addresses?
select monthly_rental from student_addresses order by monthly_rental desc limit 1
And what is the zip postcode of the address with monthly rental 1297.807?
select t1.zip_postcode from addresses as t1 join student_addresses as t2 on t1.address_id = t2.address_id where t2.monthly_rental = 1297.807
And can you also tell me the line 1 value from the table Addresses for the same property?
select t1.line_1 from addresses as t1 join student_addresses as t2 on t1.address_id = t2.address_id where t2.monthly_rental = 1297.807
Hmmm...can you also please tell me the address id for this same property?
select t1.address_id from addresses as t1 join student_addresses as t2 on t1.address_id = t2.address_id where t2.monthly_rental = 1297.807