Table: football_club_stats
Columns: season
league
rank
games
points
gf
ga
manager
top_scorer
goals

Question: Who is the top scorer where gf is 41?
SQL: SELECT "top_scorer" FROM football_club_stats WHERE "gf" = 41

Question: How many goals were scored in the 2005-06 season?
SQL: SELECT "goals" FROM football_club_stats WHERE "season" = '2005-06'

Question: How many seasons had a rank of 16?
SQL: SELECT COUNT("season") FROM football_club_stats WHERE "rank" = 16

Question: Who is the manager whose rank is 16?
SQL: SELECT "manager" FROM football_club_stats WHERE "rank" = 16

Question: What is the rank of manager Rob Mcdonald?
SQL: SELECT COUNT("rank") FROM football_club_stats WHERE "manager" = 'Rob McDonald'