In which parks does the team "Washington Nationals" play games?
select park from team where name = "Washington Nationals" group by park
How many players have played for this team?
select count(*) from salary as t1 join player as t2 on t1.player_id = t2.player_id join team as t3 on t3.team_id_br = t1.team_id where t3.name = 'Washington Nationals'
Could you please list their full names?
select t2.name_first, t2.name_last from salary as t1 join player as t2 on t1.player_id = t2.player_id join team as t3 on t3.team_id_br = t1.team_id where t3.name = 'Washington Nationals' group by t2.player_id
How about names of the players that played for this team in both 2005 and 2007
select t2.name_first, t2.name_last from salary as t1 join player as t2 on t1.player_id = t2.player_id join team as t3 on t3.team_id_br = t1.team_id where t1.year = 2005 and t3.name = 'Washington Nationals' intersect select t2.name_first, t2.name_last from salary as t1 join player as t2 on t1.player_id = t2.player_id join team as t3 on t3.team_id_br = t1.team_id where t1.year = 2007 and t3.name = 'Washington Nationals'