What is the highest rank of the day with a gross of $38,916 and more than 6 screens?
CREATE TABLE table_name_27 (rank INTEGER, gross VARCHAR, screens VARCHAR)
SELECT MAX(rank) FROM table_name_27 WHERE gross = "$38,916" AND screens > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (rank INTEGER, gross VARCHAR, screens VARCHAR) Question: What is the highest rank of the day with a gross of $38,916 and more than 6 screens? [/INST] SELECT MAX(rank) FROM table_name_27 WHERE gross = "$38,916" AND screens > 6 </s>