human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Date, Visitor, Score, Home, Leading scorer, Attendance, Record
###Question: What was the record of the game where the Rockets were the visiting team?
gpt
SELECT Record FROM table WHERE Visitor = rockets