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 "notes_and_references" (
  "school" text,
  "location" text,
  "total" real,
  "crimean_war" real,
  "persian_war" real,
  "indian_mutiny" real,
  "1860_1878" real,
  "zulu_war" real,
  "second_afghan_war" text
);
SELECT AVG("crimean_war") FROM "notes_and_references" WHERE "second_afghan_war"='1' AND "school"='hamblin and porter''s school, cork';