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

What is the average decile with Years of 1 8, and an Area of waipara?
SELECT AVG("Decile") FROM table_67631 WHERE "Years" = '1–8' AND "Area" = 'waipara'
SELECT AVG("Decile") FROM "table_67631" WHERE "Area" = 'waipara' AND "Years" = '1–8'