CREATE TABLE table_name_8 (scorers VARCHAR2, venue VARCHAR2, opponent VARCHAR2)

Who was in a with opponent St. Johnstone?
SELECT scorers FROM table_name_8 WHERE venue = "a" AND opponent = "st. johnstone"
SELECT "scorers" FROM "table_name_8" WHERE "a" = "venue" AND "opponent" = "st. johnstone"