Find the information about all the suppliers.
select * from suppliers
Sort them in the alphabetical order of their addresses.
select * from suppliers as t1 join supplier_addresses as t2 on t1.supplier_id = t2.supplier_id join addresses as t3 on t2.address_id = t3.address_id order by t3.address_details
Show the name and phone number of all suppliers in the alphabetical order of their addresses.
select t1.supplier_name, t1.supplier_phone from suppliers as t1 join supplier_addresses as t2 on t1.supplier_id = t2.supplier_id join addresses as t3 on t2.address_id = t3.address_id order by t3.address_details