Table: archie_thompson
Columns: name
years
a_league
finals
total

Question: What years have 10 (0) in the finals?
SQL: SELECT "years" FROM archie_thompson WHERE "finals" = '10 (0)'

Question: What A-League has 6 (1) for the finals, and leigh broxham as the name?
SQL: SELECT "a_league" FROM archie_thompson WHERE "finals" = '6 (1)' AND "name" = 'leigh broxham'

Question: What finals have grant brebner as the name?
SQL: SELECT "finals" FROM archie_thompson WHERE "name" = 'grant brebner'

Question: What years have 9 (0) as the finals and 133 (1) as the A-League?
SQL: SELECT "years" FROM archie_thompson WHERE "finals" = '9 (0)' AND "a_league" = '133 (1)'

Question: What years have 9 (3) as the finals?
SQL: SELECT "years" FROM archie_thompson WHERE "finals" = '9 (3)'

Question: What years have 101 (16) as the total?
SQL: SELECT "years" FROM archie_thompson WHERE "total" = '101 (16)'