How many Premierships have Nicknamed of kangaroos?
CREATE TABLE table_name_72 (no_of_premierships VARCHAR, nickname VARCHAR)
SELECT COUNT(no_of_premierships) FROM table_name_72 WHERE nickname = "kangaroos"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_72 (no_of_premierships VARCHAR, nickname VARCHAR) Question: How many Premierships have Nicknamed of kangaroos? [/INST] SELECT COUNT(no_of_premierships) FROM table_name_72 WHERE nickname = "kangaroos" </s>