Table: geelong_football_players_3
Columns: order
name
seasons
games
goals

Question: Which name has an Order smaller than 997,more than 5 goals, and 215 games?
SQL: SELECT "name" FROM geelong_football_players_3 WHERE "order" < 997 AND "goals" > 5 AND "games" = 215

Question: How many games have an Order of 1006, and Goals larger than 192?
SQL: SELECT SUM("games") FROM geelong_football_players_3 WHERE "order" = 1006 AND "goals" > 192

Question: Which game has an order larger than 975, Seasons of 2005 – 2007, and 46 goals?
SQL: SELECT "games" FROM geelong_football_players_3 WHERE "order" > 975 AND "seasons" = '2005 – 2007' AND "goals" = 46