Table: footy_kicks
Columns: player
team
opponent
year
score

Question: What richmond player played against st kilda?
SQL: SELECT "player" FROM footy_kicks WHERE "opponent" = 'st kilda' AND "team" = 'richmond'

Question: What player played in 2000?
SQL: SELECT "player" FROM footy_kicks WHERE "year" = 2000

Question: What year for geelong player john roberts?
SQL: SELECT "year" FROM footy_kicks WHERE "opponent" = 'geelong' AND "player" = 'john roberts'