CREATE TABLE table_name_27 (name VARCHAR2, authority VARCHAR2, roll VARCHAR2)

Which school has a state authority and a roll of 318?
SELECT name FROM table_name_27 WHERE authority = "state" AND roll = 318
SELECT "name" FROM "table_name_27" WHERE "authority" = "state" AND "roll" = 318