What is the average Total, when Bronze is greater than 0, when Silver is greater than 0, when Gold is greater than 2, and when Nation is Soviet Union?
CREATE TABLE "medal_table" (
  "rank" text,
  "nation" text,
  "gold" real,
  "silver" real,
  "bronze" real,
  "total" real
);
SELECT AVG("total") FROM "medal_table" WHERE "bronze">0 AND "silver">0 AND "gold">2 AND "nation"='soviet union';