Table: goalkeeper_stats
Columns: rank
player
nation
shutouts
games
years

Question: Which player has less than 201 games, is ranked 2, and played between 2007-2012?
SQL: SELECT "player" FROM goalkeeper_stats WHERE "games" < 201 AND "rank" = 2 AND "years" = '2007-2012'

Question: How many average games did Nick Rimando have?
SQL: SELECT AVG("games") FROM goalkeeper_stats WHERE "player" = 'nick rimando'