Table: forbes_global_2000_5
Columns: rank
company
headquarters
industry
sales_billion
profits_billion
assets_billion
market_value_billion

Question: What is the highest market value in billions of the company with profits of 20.96 billions and 166.99 billions in assets?
SQL: SELECT MAX("market_value_billion") FROM forbes_global_2000_5 WHERE "profits_billion" = 20.96 AND "assets_billion" > 166.99

Question: What is the total market value in billions of the company with 20.96 billion in profits and less than 166.99 billions in assets?
SQL: SELECT COUNT("market_value_billion") FROM forbes_global_2000_5 WHERE "profits_billion" = 20.96 AND "assets_billion" < 166.99

Question: What is the average assets in billions of the company Bank of America, which has less than 49.01 billions in sales?
SQL: SELECT AVG("assets_billion") FROM forbes_global_2000_5 WHERE "company" = 'bank of america' AND "sales_billion" < 49.01

Question: What is the highest profits in billions of the company headquartered in the USA with a market value of 194.87 billions and less than 76.66 billions in sales?
SQL: SELECT MAX("profits_billion") FROM forbes_global_2000_5 WHERE "headquarters" = 'usa' AND "market_value_billion" = 194.87 AND "sales_billion" < 76.66