Table: game_seven_results
Columns: year
series
winning_team
losing_team
score
site

Question: What was the latest year that the Atlanta Braves won and the St. Louis Cardinals lost?
SQL: SELECT MAX("year") FROM game_seven_results WHERE "winning_team" = 'atlanta braves' AND "losing_team" = 'st. louis cardinals'

Question: Who won the series when the San Francisco Giants lost?
SQL: SELECT "winning_team" FROM game_seven_results WHERE "losing_team" = 'san francisco giants'

Question: Where was the series that the Kansas City Royals lost?
SQL: SELECT "site" FROM game_seven_results WHERE "winning_team" = 'kansas city royals'

Question: Who was the winning team in 2008?
SQL: SELECT "winning_team" FROM game_seven_results WHERE "year" = 2008