ใครเป็นคนร้องเพลงชื่อ "Le Pop"?
Who performed the song named "Le Pop"?
df_Band = pd.DataFrame(columns=['firstname', 'lastname', 'id']); df_Performance = pd.DataFrame(columns=['bandmate', 'SongId']); df_Songs = pd.DataFrame(columns=['SongId', 'Title'])
df_Band[df_Band['id'].isin(df_Performance[df_Performance['SongId'].isin(df_Songs[df_Songs['Title'] == 'Le Pop']['SongId'])]['bandmate'])][['firstname', 'lastname']]