How many UK events won for the contestant that won under 1 US event?
CREATE TABLE "contestants" (
  "name" text,
  "from" text,
  "discipline" text,
  "events_won_uk_series" real,
  "events_won_us_series" real
);
SELECT "events_won_uk_series" FROM "contestants" WHERE "events_won_us_series"<1;