What was the attendance when they had a ranking of #4?
CREATE TABLE table_name_42 (attendance VARCHAR, rank__number VARCHAR)
SELECT attendance FROM table_name_42 WHERE rank__number = "4"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (attendance VARCHAR, rank__number VARCHAR) Question: What was the attendance when they had a ranking of #4? [/INST] SELECT attendance FROM table_name_42 WHERE rank__number = "4" </s>