CREATE TABLE table_11937 ("Name" CLOB, "Years" CLOB, "Gender" CLOB, "Area" CLOB, "Authority" CLOB, "Decile" FLOAT, "Roll" FLOAT)

Which name has an authority of state?
SELECT "Name" FROM table_11937 WHERE "Authority" = 'state'
SELECT "Name" FROM "table_11937" WHERE "Authority" = 'state'