รหัสไปรษณีย์ของลูกค้าชื่อ Carole และนามสกุล Bernhard คืออะไร?
What is zip code of customer with first name as Carole and last name as Bernhard?
df_addresses = pd.DataFrame(columns=['zip_postcode', 'address_id'])
df_customers = pd.DataFrame(columns=['customer_address_id', 'first_name', 'last_name'])
df_addresses[df_addresses['address_id'].isin(df_customers[(df_customers['first_name'] == 'Carole') & (df_customers['last_name'] == 'Bernhard')]['customer_address_id'])]['zip_postcode'].iloc[0]