How many premierships for the commonwealth bank trophy league?
CREATE TABLE table_name_25 (premierships VARCHAR, league VARCHAR)
SELECT premierships FROM table_name_25 WHERE league = "commonwealth bank trophy"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_25 (premierships VARCHAR, league VARCHAR) Question: How many premierships for the commonwealth bank trophy league? [/INST] SELECT premierships FROM table_name_25 WHERE league = "commonwealth bank trophy" </s>