CREATE TABLE table_204_703 (id NUMBER, "rank" NUMBER, "nation" CLOB, "gold" NUMBER, "silver" NUMBER, "bronze" NUMBER, "total" NUMBER)

which country won more total medals than tue french , but less than the germans in the 1994 winter olympic biathlon ?
SELECT "nation" FROM table_204_703 WHERE "total" > (SELECT "total" FROM table_204_703 WHERE "nation" = 'france') AND "total" < (SELECT "total" FROM table_204_703 WHERE "nation" = 'germany')
SELECT "nation" FROM "table_204_703" WHERE "total" < (SELECT "total" FROM "table_204_703" WHERE "nation" = 'germany') AND "total" > (SELECT "total" FROM "table_204_703" WHERE "nation" = 'france')