question: Which Visitor was there when the Home game was played in Miami on November 4?
answer: SELECT visitor FROM table_name_80 WHERE home = "miami" AND date = "november 4"
context: CREATE TABLE table_name_80 (visitor VARCHAR, home VARCHAR, date VARCHAR)