What is the average decile of Ruapehu college, which has a state authority?
CREATE TABLE table_name_64 (
    decile INTEGER,
    authority VARCHAR,
    name VARCHAR
)
SELECT AVG(decile) FROM table_name_64 WHERE authority = "state" AND name = "ruapehu college"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the average decile of Ruapehu college, which has a state authority? ### Input: CREATE TABLE table_name_64 (
    decile INTEGER,
    authority VARCHAR,
    name VARCHAR
) ### Response: SELECT AVG(decile) FROM table_name_64 WHERE authority = "state" AND name = "ruapehu college"