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 (crimean_war INTEGER, second_afghan_war VARCHAR, school VARCHAR)
  ### Question:
  What is the average Crimean War with a Second Afghan War totaling 1, and a School of hamblin and porter's school, cork?
  ### Answer:
  SELECT AVG(crimean_war) FROM table_name_49 WHERE second_afghan_war = "1" AND school = "hamblin and porter's school, cork"