Table: scottish_football_managers
Columns: manager
nationality
date_of_birth_and_age
club
division

Question: Who is the manager of the St. Johnstone club?
SQL: SELECT "manager" FROM scottish_football_managers WHERE "club" = 'st. johnstone'

Question: Who is the manager of the Stenhousemuir club?
SQL: SELECT "manager" FROM scottish_football_managers WHERE "club" = 'stenhousemuir'