Which company had a market value less than $5.59 billion, assets greater than $27.46 billion, and a rank above 39?
CREATE TABLE table_name_87 (name VARCHAR, assets__bn$_ VARCHAR, market_value__bn$_ VARCHAR, rank VARCHAR)
SELECT name FROM table_name_87 WHERE market_value__bn$_ < 5.59 AND rank > 39 AND assets__bn$_ > 27.46
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_87 (name VARCHAR, assets__bn$_ VARCHAR, market_value__bn$_ VARCHAR, rank VARCHAR) Question: Which company had a market value less than $5.59 billion, assets greater than $27.46 billion, and a rank above 39? [/INST] SELECT name FROM table_name_87 WHERE market_value__bn$_ < 5.59 AND rank > 39 AND assets__bn$_ > 27.46 </s>