Table: geelong_football_players_2
Columns: order
name
seasons
games
goals

Question: What is total orders for goals of 239?
SQL: SELECT COUNT("order") FROM geelong_football_players_2 WHERE "goals" = 239

Question: Who had an order of 907 and more than 1 game?
SQL: SELECT "name" FROM geelong_football_players_2 WHERE "games" > 1 AND "order" = 907

Question: What seasons had 288 games and more than 100 goals?
SQL: SELECT "seasons" FROM geelong_football_players_2 WHERE "goals" > 100 AND "games" = 288

Question: What is the low goal for orders more than 939 during Seasons of 1996 – 2001?
SQL: SELECT MIN("goals") FROM geelong_football_players_2 WHERE "seasons" = '1996 – 2001' AND "order" > 939