CREATE TABLE table_name_42 (roll VARCHAR2, authority VARCHAR2, decile VARCHAR2)

What is the roll for the school with state authority and a decile of 9?
SELECT roll FROM table_name_42 WHERE authority = "state" AND decile = 9
SELECT "roll" FROM "table_name_42" WHERE "authority" = "state" AND "decile" = 9