How many semifinalists had a total less than 2, 1st RU greater than 0, 2nd RU was 0 and Miss United Continent of 0?
CREATE TABLE "by_country_tally" (
  "rank" real,
  "country" text,
  "miss_united_continent" real,
  "virreina" real,
  "1st_ru" real,
  "2nd_ru" real,
  "3rd_ru" real,
  "4th_ru" real,
  "semifinalists" real,
  "total" real
);
SELECT COUNT("semifinalists") FROM "by_country_tally" WHERE "miss_united_continent"=0 AND "2nd_ru"=0 AND "1st_ru">0 AND "total"<2;