Database: election
Question: For each delegate, find the names of the party they are part of.
SQL:
SELECT T1.Delegate ,  T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID