Which Visitor was there when the Home game was played in Miami on November 4?
CREATE TABLE table_name_80 (visitor VARCHAR, home VARCHAR, date VARCHAR)
SELECT visitor FROM table_name_80 WHERE home = "miami" AND date = "november 4"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_80 (visitor VARCHAR, home VARCHAR, date VARCHAR) Question: Which Visitor was there when the Home game was played in Miami on November 4? [/INST] SELECT visitor FROM table_name_80 WHERE home = "miami" AND date = "november 4" </s>