Table: football_match_results_4
Columns: date
round
opponent
venue
result
attendance
scorers

Question: Who was in a with opponent St. Johnstone?
SQL: SELECT "scorers" FROM football_match_results_4 WHERE "venue" = 'a' AND "opponent" = 'st. johnstone'

Question: What venue was on 27 May 2000?
SQL: SELECT "venue" FROM football_match_results_4 WHERE "date" = '27 may 2000'

Question: Who was on 12 March 2000?
SQL: SELECT "scorers" FROM football_match_results_4 WHERE "date" = '12 march 2000'