Which Rank is the lowest one that has a Gross of $54,215,416?
CREATE TABLE table_name_24 (rank INTEGER, gross VARCHAR)
SELECT MIN(rank) FROM table_name_24 WHERE gross = "$54,215,416"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_24 (rank INTEGER, gross VARCHAR) Question: Which Rank is the lowest one that has a Gross of $54,215,416? [/INST] SELECT MIN(rank) FROM table_name_24 WHERE gross = "$54,215,416" </s>