CREATE TABLE HOST (Name VARCHAR2, Host_ID VARCHAR2)
CREATE TABLE party_host (Host_ID VARCHAR2, Party_ID VARCHAR2)
CREATE TABLE party (Party_Theme VARCHAR2, Party_ID VARCHAR2)

Show the themes of parties and the names of the party hosts.
SELECT T3.Party_Theme, T2.Name FROM party_host AS T1 JOIN HOST AS T2 ON T1.Host_ID = T2.Host_ID JOIN party AS T3 ON T1.Party_ID = T3.Party_ID
SELECT "T3"."Party_Theme", "T2"."Name" FROM "party_host" "T1" JOIN "HOST" "T2" ON "T1"."Host_ID" = "T2"."Host_ID" JOIN "party" "T3" ON "T1"."Party_ID" = "T3"."Party_ID"