How many Seasons that has Years of 1976–1977?
CREATE TABLE table_name_1 (seasons VARCHAR, years VARCHAR)
SELECT COUNT(seasons) FROM table_name_1 WHERE years = "1976–1977"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (seasons VARCHAR, years VARCHAR) Question: How many Seasons that has Years of 1976–1977? [/INST] SELECT COUNT(seasons) FROM table_name_1 WHERE years = "1976–1977" </s>