Table: player_stats_11
Columns: rank
player
goals
games
goal_ratio

Question: What is the largest value for goals in rank over 3 with goal ration of 0.54?
SQL: SELECT MAX("goals") FROM player_stats_11 WHERE "rank" > 3 AND "goal_ratio" = 0.54

Question: How many goal ratios have rank of 2 with more than 44 games?
SQL: SELECT COUNT("goal_ratio") FROM player_stats_11 WHERE "rank" = 2 AND "games" > 44

Question: How many games have 23 goals with a rank greater than 9?
SQL: SELECT COUNT("games") FROM player_stats_11 WHERE "goals" = 23 AND "rank" > 9

Question: How many goals have a goal ration less than 0.8 with 56 games?
SQL: SELECT COUNT("goals") FROM player_stats_11 WHERE "goal_ratio" < 0.8 AND "games" = 56