What is the average Crimean War with a Second Afghan War totaling 1, and a School of hamblin and porter's school, cork?
CREATE TABLE table_name_49 (
    crimean_war INTEGER,
    second_afghan_war VARCHAR,
    school VARCHAR
)
SELECT AVG(crimean_war) FROM table_name_49 WHERE second_afghan_war = "1" AND school = "hamblin and porter's school, cork"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the average Crimean War with a Second Afghan War totaling 1, and a School of hamblin and porter's school, cork? ### Input: CREATE TABLE table_name_49 (
    crimean_war INTEGER,
    second_afghan_war VARCHAR,
    school VARCHAR
) ### Response: SELECT AVG(crimean_war) FROM table_name_49 WHERE second_afghan_war = "1" AND school = "hamblin and porter's school, cork"