Show me a list of party themes
select party_theme from party
Can you show me the corresponding party id and host id to each theme?
select t1.party_id, t1.host_id, t3.party_theme 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
Can you add host names to that table?
select t2.name, t1.party_id, t1.host_id, t3.party_theme 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