CREATE TABLE county (county_id NUMBER, county_name CLOB, population NUMBER, zip_code CLOB)
CREATE TABLE party (party_id NUMBER, year NUMBER, party CLOB, governor CLOB, lieutenant_governor CLOB, comptroller CLOB, attorney_general CLOB, us_senate CLOB)
CREATE TABLE election (election_id NUMBER, counties_represented CLOB, district NUMBER, delegate CLOB, party NUMBER, first_elected NUMBER, committee CLOB)

For each delegate, find the names of the party they are part of.
SELECT T1.delegate, T2.party FROM election AS T1 JOIN party AS T2 ON T1.party = T2.party_id
SELECT "T1"."delegate", "T2"."party" FROM "election" "T1" JOIN "party" "T2" ON "T1"."party" = "T2"."party_id"