CREATE TABLE table_name_25 (premierships VARCHAR, league VARCHAR)

How many premierships for the commonwealth bank trophy league?
SELECT premierships FROM table_name_25 WHERE league = "commonwealth bank trophy"
SELECT "premierships" FROM "table_name_25" WHERE "commonwealth bank trophy" = "league"