human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Week, Date, Opponent, Result, Record, Game Site, Attendance
###Question: When it is week 2 what is the record?
gpt
SELECT Record FROM table WHERE Week = 2