CREATE TABLE table_name_96 (roll NUMBER, name VARCHAR2, gender VARCHAR2, authority VARCHAR2)

Name the highest roll for coed and authority of state integrated with sacred heart school
SELECT MAX(roll) FROM table_name_96 WHERE gender = "coed" AND authority = "state integrated" AND name = "sacred heart school"
SELECT MAX("roll") FROM "table_name_96" WHERE "authority" = "state integrated" AND "coed" = "gender" AND "name" = "sacred heart school"