What is the total rank of the company with less than 248.44 billion in assets, an industry of oil and gas, headquarters in France, and a market value greater than 152.62 billions?
CREATE TABLE table_name_92 (rank VARCHAR, market_value__billion_$_ VARCHAR, headquarters VARCHAR, assets__billion_$_ VARCHAR, industry VARCHAR)
SELECT COUNT(rank) FROM table_name_92 WHERE assets__billion_$_ < 248.44 AND industry = "oil and gas" AND headquarters = "france" AND market_value__billion_$_ > 152.62
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_92 (rank VARCHAR, market_value__billion_$_ VARCHAR, headquarters VARCHAR, assets__billion_$_ VARCHAR, industry VARCHAR) Question: What is the total rank of the company with less than 248.44 billion in assets, an industry of oil and gas, headquarters in France, and a market value greater than 152.62 billions? [/INST] SELECT COUNT(rank) FROM table_name_92 WHERE assets__billion_$_ < 248.44 AND industry = "oil and gas" AND headquarters = "france" AND market_value__billion_$_ > 152.62 </s>