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: Quantas semanas um Oponente do New York Giants tem?
 ###Tabelas: CREATE TABLE ap_poll (ap_poll_id AUTO_INCREMENT PRIMARY KEY, Preseason VARCHAR, Week 1 Aug 26 VARCHAR, Week 2 Sept 2 VARCHAR, Week 3 Sept 8 VARCHAR, Week 4 Sept 15 VARCHAR, Week 5 Sept 22 VARCHAR, Week 6 Sept 29 VARCHAR, Week 7 Oct 6 VARCHAR, Week 8 Oct 13 VARCHAR, Week 9 Oct 20 VARCHAR, Week 10 Oct 27 VARCHAR, Week 11 Nov 3 VARCHAR, Week 12 Nov 10 VARCHAR, Week 13 Nov 17 VARCHAR, Week 14 Nov 24 VARCHAR, Week 15 Dec 1 VARCHAR, Week 16 Dec 8 VARCHAR, Week 17 (Final) Jan 4 VARCHAR) CREATE TABLE orders (orders_id AUTO_INCREMENT PRIMARY KEY, Lot No. INT, Diagram INT, Mark VARCHAR, Builder VARCHAR, Fleet numbers VARCHAR, Notes VARCHAR) CREATE TABLE department_of_skills_development (department_of_skills_development_id AUTO_INCREMENT PRIMARY KEY, Name in English VARCHAR, Name in Malay VARCHAR, Acronym VARCHAR, Foundation VARCHAR, Location VARCHAR) CREATE TABLE schedule (schedule_id AUTO_INCREMENT PRIMARY KEY, Week INT, Date VARCHAR, Opponent VARCHAR, Time ( ET ) VARCHAR, Result VARCHAR) CREATE TABLE batteries (batteries_id AUTO_INCREMENT PRIMARY KEY, Technology VARCHAR, Moving Parts VARCHAR, Room Temperature VARCHAR, Flammable VARCHAR, Toxic Materials VARCHAR, In production VARCHAR, Rare metals VARCHAR)  
SELECT COUNT Week FROM schedule WHERE Opponent = at new york giants