CREATE TABLE table_47307 ("Rank" FLOAT, "Rank Forbes 2000" FLOAT, "Name" CLOB, "Headquarters" CLOB, "Revenue  ( Bn.$ ) " FLOAT, "Profit  ( Bn.$ ) " FLOAT, "Assets  ( Bn.$ ) " FLOAT, "Market value  ( Bn.$ ) " FLOAT, "Industry" CLOB)

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