CREATE TABLE table_name_78 (area VARCHAR2, authority VARCHAR2, roll VARCHAR2)

Which area has state authority and a roll fewer than 18?
SELECT area FROM table_name_78 WHERE authority = "state" AND roll < 18
SELECT "area" FROM "table_name_78" WHERE "authority" = "state" AND "roll" < 18