Table 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?
SQL: SELECT COUNT(decile) FROM table_name_95 WHERE years = "1–8" AND roll = 49