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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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? ### Input: CREATE TABLE table_name_92 (
    rank VARCHAR,
    market_value__billion_$_ VARCHAR,
    headquarters VARCHAR,
    assets__billion_$_ VARCHAR,
    industry VARCHAR
) ### Response: 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