Table: footy_kicks_2
Columns: player
team
opponent
year
score
outcome

Question: What most recent year had North Melbourne as a team and Hamish Mcintosh as a player?
SQL: SELECT MAX("year") FROM footy_kicks_2 WHERE "team" = 'north melbourne' AND "player" = 'hamish mcintosh'

Question: Which score had Essendon as an opponent and Steven Clark as a player?
SQL: SELECT "score" FROM footy_kicks_2 WHERE "opponent" = 'essendon' AND "player" = 'steven clark'

Question: Which team got a Behind outcome and had an opponent of Brisbane Bears?
SQL: SELECT "team" FROM footy_kicks_2 WHERE "outcome" = 'behind' AND "opponent" = 'brisbane bears'