Show me the monthly rentals for all student addresses.
select address_id, monthly_rental from student_addresses
What are their corresponding state, province, or county?
select t2.address_id, t2.monthly_rental,t1.state_province_county from addresses as t1 join student_addresses as t2 on t1.address_id = t2.address_id
Show me the monthly rentals from Texas.
select t2.monthly_rental from addresses as t1 join student_addresses as t2 on t1.address_id = t2.address_id where t1.state_province_county = "Texas"