Table schema:
CREATE TABLE table_1165048_1 (captain VARCHAR, coach VARCHAR)

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