Optimize multiple join same table
I have two tables: student, address. address includes id and location student includes id, name, roommate_id, location_id. I need to find student's info with student location and roommate location. I have used the query:...