Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual número da semana teve o New York Giants como oponente?
 ###Tabelas: CREATE TABLE western_conference_finals (western_conference_finals_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Visitor VARCHAR, Score VARCHAR, Home VARCHAR, Decision VARCHAR, Attendance INT) CREATE TABLE season_1_2007 (season_1_2007_id AUTO_INCREMENT PRIMARY KEY, Series no. INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Original air date VARCHAR, Production Code INT) CREATE TABLE discography_-_original_releases (discography_-_original_releases_id AUTO_INCREMENT PRIMARY KEY, Year INT, Song (s) VARCHAR, Producer (s) VARCHAR, Written By VARCHAR, Artist VARCHAR, Title/Label VARCHAR) CREATE TABLE schedule (schedule_id AUTO_INCREMENT PRIMARY KEY, Week INT, Date VARCHAR, Opponent VARCHAR, Result VARCHAR, Attendance VARCHAR) CREATE TABLE railway_stations_currently_in_use (railway_stations_currently_in_use_id AUTO_INCREMENT PRIMARY KEY, Station (and code) VARCHAR, Managed by VARCHAR, Lines served VARCHAR, Station users 2007/8 INT, Station users 2008/9 VARCHAR, Year opened VARCHAR, Platforms VARCHAR, Borough VARCHAR)  
SELECT COUNT Week FROM schedule WHERE Opponent = new york giants