Task: Text to Code
Input (English): Step 1: For each row in party_host table, find corresponding rows in party table and in host table.
Step 2: find Party_Theme of the results of step 1 whose Age greater than 50
Output (English): SELECT T1.Party_Theme FROM party AS T1 JOIN host AS T2 JOIN party_host AS T3 ON T1.Party_ID = T3.Party_ID AND T3.Host_ID = T2.Host_ID WHERE T2.Age > 50