How many deciles have Years of 1–8, and a Roll of 49?
CREATE TABLE table_name_95 (decile VARCHAR, years VARCHAR, roll VARCHAR)
SELECT COUNT(decile) FROM table_name_95 WHERE years = "1–8" AND roll = 49
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_95 (decile VARCHAR, years VARCHAR, roll VARCHAR) Question: How many deciles have Years of 1–8, and a Roll of 49? [/INST] SELECT COUNT(decile) FROM table_name_95 WHERE years = "1–8" AND roll = 49 </s>