What is the average rank for a building with 24 floors?
CREATE TABLE table_name_84 (rank INTEGER, floors VARCHAR)
SELECT AVG(rank) FROM table_name_84 WHERE floors = 24
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_84 (rank INTEGER, floors VARCHAR) Question: What is the average rank for a building with 24 floors? [/INST] SELECT AVG(rank) FROM table_name_84 WHERE floors = 24 </s>