เงินเดือนทั้งหมดที่ทีม Boston Red Stockings จ่ายในปี 2010 เป็นเท่าใด
What is the total salary paid by team Boston Red Stockings in 2010?
df_salary = pd.DataFrame(columns=['salary', 'team_id', 'year']); df_team = pd.DataFrame(columns=['team_id_br', 'name'])
df_salary[(df_salary['year'] == '2010') & (df_salary['team_id'] == df_team[df_team['name'] == 'Boston Red Stockings']['team_id_br'].values[0])]['salary'].sum()