Who was in a with opponent St. Johnstone?
CREATE TABLE table_name_8 (scorers VARCHAR, venue VARCHAR, opponent VARCHAR)
SELECT scorers FROM table_name_8 WHERE venue = "a" AND opponent = "st. johnstone"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (scorers VARCHAR, venue VARCHAR, opponent VARCHAR) Question: Who was in a with opponent St. Johnstone? [/INST] SELECT scorers FROM table_name_8 WHERE venue = "a" AND opponent = "st. johnstone" </s>