What is the sum of revenue in Hong Kong with a rank greater than 42, less than $3.46 billion in assets, and greater than $0.17 billion in profits?
CREATE TABLE "list" (
  "rank" real,
  "rank_forbes_2000" real,
  "name" text,
  "headquarters" text,
  "revenue_bn" real,
  "profit_bn" real,
  "assets_bn" real,
  "market_value_bn" real,
  "industry" text
);
SELECT SUM("revenue_bn") FROM "list" WHERE "assets_bn"<3.46 AND "headquarters"='hong kong' AND "profit_bn">0.17 AND "rank">42;