Which Attendance has a Result of 1-0, and a Venue of A, and an Opponent of newcastle united?
CREATE TABLE table_name_77 (attendance INTEGER, opponent VARCHAR, result VARCHAR, venue VARCHAR)
SELECT MIN(attendance) FROM table_name_77 WHERE result = "1-0" AND venue = "a" AND opponent = "newcastle united"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_77 (attendance INTEGER, opponent VARCHAR, result VARCHAR, venue VARCHAR) Question: Which Attendance has a Result of 1-0, and a Venue of A, and an Opponent of newcastle united? [/INST] SELECT MIN(attendance) FROM table_name_77 WHERE result = "1-0" AND venue = "a" AND opponent = "newcastle united" </s>