user: Question: What is the average Crimean War with a Second Afghan War totaling 1, and a School of hamblin and porter's school, cork?
Columns: ['School', 'Location', 'Total', 'Crimean War', 'Persian War', 'Indian Mutiny', '1860-1878', 'Zulu War', 'Second Afghan War']
Types: ['text', 'text', 'real', 'real', 'real', 'real', 'real', 'real', 'text']
Sample row: ['Eton College', 'United Kingdom', 37.0, 4.0, 0.0, 3.0, 1.0, 2.0, '0']
SQL:

assistant: SELECT AVG("Crimean War") FROM "Table" WHERE "Second Afghan War" = '1' AND "School" = 'hamblin and porter''s school, cork';