What is the lowest value of a team with revenue less than 374 and a debt of 84%?
CREATE TABLE "2007_rankings" (
  "team" text,
  "country" text,
  "value_m" real,
  "debt_as_pctof_value" text,
  "pct_change_on_year" text,
  "revenue_m" real,
  "operating_income_m" real
);
SELECT MIN("value_m") FROM "2007_rankings" WHERE "revenue_m"<374 AND "debt_as_pctof_value"='84';