CREATE TABLE table_58495 ("Name" CLOB, "Years" CLOB, "Area" CLOB, "Authority" CLOB, "Decile" CLOB, "Roll" CLOB)

What is the roll number of the school with a state authority in Waiotira?
SELECT "Roll" FROM table_58495 WHERE "Authority" = 'state' AND "Area" = 'waiotira'
SELECT "Roll" FROM "table_58495" WHERE "Area" = 'waiotira' AND "Authority" = 'state'