When the opponent was Brechin City and the attendance was 656, what was the Result?
CREATE TABLE table_name_47 (result VARCHAR, opponent VARCHAR, attendance VARCHAR)
SELECT result FROM table_name_47 WHERE opponent = "brechin city" AND attendance = 656
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (result VARCHAR, opponent VARCHAR, attendance VARCHAR) Question: When the opponent was Brechin City and the attendance was 656, what was the Result? [/INST] SELECT result FROM table_name_47 WHERE opponent = "brechin city" AND attendance = 656 </s>