user: ### NOW ANSWER:
Question:  who is the captain where coach is Geoff Miles
Columns: ['Season', 'Position', 'Win/Loss', 'Coach', 'Captain', 'Dudley Tuckey Medal', 'Leading goalkicker']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: [1997.0, 9.0, '1-19', 'Geoff Miles', 'Phil Gilbert', 'Scott Simister', 'Scott Simister (27)']
SQL:

assistant: SELECT "Captain" FROM "Table" WHERE "Coach" = 'Geoff Miles';