CREATE TABLE table_name_98 (decile INT, years VARCHAR, area VARCHAR)

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