What are the names of parties and their respective regions?
SELECT T1.party_name ,  T2.region_name FROM party AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id
names of parties = party_name; respective regions = region_name; JOIN is used to combine rows from two or more tables based on a related column between them, here it's region_id;