Table: china_largest_companies_2
Columns: rank
rank_forbes_2000
name
headquarters
revenue_bn
profit_bn
assets_bn
market_value_bn
industry

Question: Which company had a market value less than $5.59 billion, assets greater than $27.46 billion, and a rank above 39?
SQL: SELECT "name" FROM china_largest_companies_2 WHERE "market_value_bn" < 5.59 AND "rank" > 39 AND "assets_bn" > 27.46

Question: How many ranks have assets of $70.74 billion and market value greater than $11.29 billion?
SQL: SELECT COUNT("rank") FROM china_largest_companies_2 WHERE "assets_bn" = 70.74 AND "market_value_bn" > 11.29

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?
SQL: SELECT SUM("revenue_bn") FROM china_largest_companies_2 WHERE "assets_bn" < 3.46 AND "headquarters" = 'hong kong' AND "profit_bn" > 0.17 AND "rank" > 42

Question: What is the sum of revenue for the banking industry with a Forbes 2000 rank under 53?
SQL: SELECT SUM("revenue_bn") FROM china_largest_companies_2 WHERE "industry" = 'banking' AND "rank_forbes_2000" < 53