What is the average number of military deaths when there are fewer than 38 civilian deaths (including foreigners) and 33 military and/or civilian wounded?
CREATE TABLE "terror_and_other_attacks_1968_1987" (
  "military_deaths" real,
  "civilian_deaths_including_foreigners" real,
  "total_deaths" real,
  "military_and_or_civilian_wounded" text,
  "total_casualties" text
);
SELECT AVG("military_deaths") FROM "terror_and_other_attacks_1968_1987" WHERE "civilian_deaths_including_foreigners"<38 AND "military_and_or_civilian_wounded"='33';