user: 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?
Columns: ['Rank', 'Rank Forbes 2000', 'Name', 'Headquarters', 'Revenue (Bn.$)', 'Profit (Bn.$)', 'Assets (Bn.$)', 'Market value (Bn.$)', 'Industry']
Types: ['real', 'real', 'text', 'text', 'real', 'real', 'real', 'real', 'text']
Sample row: [1.0, 41.0, 'PetroChina', 'Beijing', 68.43, 16.53, 96.42, 208.76, 'Oil']
SQL:

assistant: SELECT SUM("Revenue (Bn.$)") FROM "Table" WHERE "Assets (Bn.$)" < 3.46 AND "Headquarters" = 'Hong Kong' AND "Profit (Bn.$)" > 0.17 AND "Rank" > 42.0;