CREATE TABLE table_name_80 (visitor VARCHAR, home VARCHAR, date VARCHAR)

Which Visitor was there when the Home game was played in Miami on November 4?
SELECT visitor FROM table_name_80 WHERE home = "miami" AND date = "november 4"
SELECT "visitor" FROM "table_name_80" WHERE "date" = "november 4" AND "home" = "miami"