Which company has a market value greater than 1, Assets (US$ billion) smaller than 10.7, a Rank smaller than 10, and revenue (US$ billion) of 9.3?
CREATE TABLE "forbes_global_2000" (
  "rank" real,
  "company" text,
  "revenues_us_billion" real,
  "profit_us_billion" real,
  "assets_us_billion" real,
  "market_value_us_billion" real
);
SELECT "company" FROM "forbes_global_2000" WHERE "market_value_us_billion">1 AND "assets_us_billion"<10.7 AND "rank"<10 AND "revenues_us_billion"=9.3;