CREATE TABLE table_name_49 (crimean_war INT, second_afghan_war VARCHAR, school VARCHAR)

What is the average Crimean War with a Second Afghan War totaling 1, and a School of hamblin and porter's school, cork?
SELECT AVG(crimean_war) FROM table_name_49 WHERE second_afghan_war = "1" AND school = "hamblin and porter's school, cork"
SELECT AVG("crimean_war") FROM "table_name_49" WHERE "1" = "second_afghan_war" AND "hamblin and porter's school, cork" = "school"