CREATE TABLE table_name_64 (decile INT, authority VARCHAR, name VARCHAR)

What is the average decile of Ruapehu college, which has a state authority?
SELECT AVG(decile) FROM table_name_64 WHERE authority = "state" AND name = "ruapehu college"
SELECT AVG("decile") FROM "table_name_64" WHERE "authority" = "state" AND "name" = "ruapehu college"