Table: peel_thunder_football_stats
Columns: season
position
win_loss
coach
captain
dudley_tuckey_medal
leading_goalkicker

Question:  who is the coach where dudley tuckey medal is ben howlett
SQL: SELECT "coach" FROM peel_thunder_football_stats WHERE "dudley_tuckey_medal" = 'Ben Howlett'

Question: what is the total number of coach where captain is grant welsh and win/loss is 5-15
SQL: SELECT COUNT("coach") FROM peel_thunder_football_stats WHERE "captain" = 'Grant Welsh' AND "win_loss" = '5-15'

Question:  who is the dudley tuckey medal where leading goalkicker is scott simister (46)
SQL: SELECT "dudley_tuckey_medal" FROM peel_thunder_football_stats WHERE "leading_goalkicker" = 'Scott Simister (46)'

Question: what is the maximum season where leading goalkicker is scott simister (54)
SQL: SELECT MAX("season") FROM peel_thunder_football_stats WHERE "leading_goalkicker" = 'Scott Simister (54)'

Question: what are all the win/loss where season is 2009
SQL: SELECT "win_loss" FROM peel_thunder_football_stats WHERE "season" = 2009

Question:  who is the captain where coach is geoff miles
SQL: SELECT "captain" FROM peel_thunder_football_stats WHERE "coach" = 'Geoff Miles'