CREATE TABLE table_14986 ("Name" CLOB, "Years" CLOB, "Gender" CLOB, "Area" CLOB, "Authority" CLOB, "Decile" FLOAT, "Roll" FLOAT)

How many deciles have Years of 1 8, and a Roll of 49?
SELECT COUNT("Decile") FROM table_14986 WHERE "Years" = '1–8' AND "Roll" = '49'
SELECT COUNT("Decile") FROM "table_14986" WHERE "Roll" = '49' AND "Years" = '1–8'