นักดนตรีชื่อ "Solveig" ร้องเพลงประเภทใดในเพลงชื่อ "A Bar in Amsterdam"
Which vocal type did the musician with first name "Solveig" played in the song with title "A Bar in Amsterdam"?
df_vocals = pd.DataFrame(columns=['songid', 'bandmate']); df_band = pd.DataFrame(columns=['id', 'firstname']); df_songs = pd.DataFrame(columns=['songid', 'title'])
df_vocals[(df_vocals['bandmate'].isin(df_band[df_band['firstname'] == 'Solveig']['id'])) & (df_vocals['songid'].isin(df_songs[df_songs['title'] == 'A Bar in Amsterdam']['songid']))]['TYPE']