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"