What is the total number of Total, when Gold is less than 1, when Silver is greater than 0, when Rank is 14, and when Nation is Afghanistan?
CREATE TABLE "medal_table" (
  "rank" text,
  "nation" text,
  "gold" real,
  "silver" real,
  "bronze" real,
  "total" real
);
SELECT COUNT("total") FROM "medal_table" WHERE "gold"<1 AND "silver">0 AND "rank"='14' AND "nation"='afghanistan';