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_49 (roll INTEGER, decile VARCHAR, years VARCHAR, name VARCHAR)
  ### Question:
  What is the largest roll with Years 1–8, a Name of dorie school, and a Decile larger than 9?
  ### Answer:
  SELECT MAX(roll) FROM table_name_49 WHERE years = "1–8" AND name = "dorie school" AND decile > 9