instruction: 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?
response: SELECT SUM("Revenue (Bn.$)") FROM table_47307 WHERE "Assets (Bn.$)" < '3.46' AND "Headquarters" = 'hong kong' AND "Profit (Bn.$)" > '0.17' AND "Rank" > '42'