Database: party_people
Question: Show all party names and their region names.
SQL:
SELECT T1.party_name ,  T2.region_name FROM party AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id