user: Question: How many premierships for the Commonwealth Bank Trophy league?
Columns: ['Club/Team', 'League', 'Venue', 'Established', 'Premierships']
Types: ['text', 'text', 'text', 'real', 'text']
Sample row: ['Brisbane Bandits', 'Australian Baseball League', 'Brisbane Exhibition Ground', 1989.0, '1']
SQL:

assistant: SELECT "Premierships" FROM "Table" WHERE "League" = 'Commonwealth Bank Trophy';