What's the average survived with a to Iran less than 1, more than 1 destroyed, and a brazil tucano aircraft?
CREATE TABLE "iraqi_air_force_strength_at_start_of_war" (
  "aircraft" text,
  "1990" real,
  "destroyed" real,
  "damaged" real,
  "to_iran" real,
  "survived" real
);
SELECT AVG("survived") FROM "iraqi_air_force_strength_at_start_of_war" WHERE "to_iran"<1 AND "aircraft"='brazil tucano' AND "destroyed">1;