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: Nomeie a média pontuada para a longa taça de 2011 e 2 de outubro de 2011.
 ###Tabelas: CREATE TABLE headstamps_and_colour-coding (headstamps_and_colour-coding_id AUTO_INCREMENT PRIMARY KEY, Headstamp ID VARCHAR, Primer Annulus Color VARCHAR, Bullet Tip Color VARCHAR, Other Features VARCHAR, Functional Type VARCHAR) CREATE TABLE 2008:_atlanta_dream (2008:_atlanta_dream_id AUTO_INCREMENT PRIMARY KEY, Pick INT, Player VARCHAR, Nationality VARCHAR, New WNBA Team VARCHAR, Former WNBA Team VARCHAR, College/Country/Team VARCHAR) CREATE TABLE current_and_former_player_information (current_and_former_player_information_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Total W-L VARCHAR, Singles W-L VARCHAR, Doubles W-L VARCHAR, No. of ties INT, First year played INT, No. of years played INT) CREATE TABLE international_career (international_career_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Venue VARCHAR, Result VARCHAR, Scored INT, Competition VARCHAR) CREATE TABLE finals:_6_3_titles_3_runners-up (finals:_6_3_titles_3_runners-up_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Year INT, Tournament VARCHAR, Partner VARCHAR, Opponent VARCHAR, Score VARCHAR)  
SELECT AVG Scored FROM international_career WHERE Competition = 2011 long teng cup AND Date = 2 october 2011