Name the averag scored for 2011 long teng cup and 2 october 2011
CREATE TABLE table_name_64 (scored INTEGER, competition VARCHAR, date VARCHAR)
SELECT AVG(scored) FROM table_name_64 WHERE competition = "2011 long teng cup" AND date = "2 october 2011"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_64 (scored INTEGER, competition VARCHAR, date VARCHAR) Question: Name the averag scored for 2011 long teng cup and 2 october 2011 [/INST] SELECT AVG(scored) FROM table_name_64 WHERE competition = "2011 long teng cup" AND date = "2 october 2011" </s>