text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_name_96 (roll INTEGER, name VARCHAR, gender VARCHAR, authority VARCHAR)
  ### Question:
  Name the highest roll for coed and authority of state integrated with sacred heart school
  ### Answer:
  SELECT MAX(roll) FROM table_name_96 WHERE gender = "coed" AND authority = "state integrated" AND name = "sacred heart school"