text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_name_98 (revenue__bn INTEGER, rank VARCHAR, profit__bn$_ VARCHAR, assets__bn$_ VARCHAR, headquarters VARCHAR)
  ### Question:
  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?
  ### Answer:
  SELECT SUM(revenue__bn) AS $_ FROM table_name_98 WHERE assets__bn$_ < 3.46 AND headquarters = "hong kong" AND profit__bn$_ > 0.17 AND rank > 42