user: ### NOW ANSWER:
Question: Who is the manager of the St. Johnstone club?
Columns: ['Manager', 'Nationality', 'Date of Birth and Age', 'Club', 'Division']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Gardner Speirs Category:Articles with hCards', 'Scotland', '14 April 1963 (age50)', "Queen's Park", 'League Two']
SQL:

assistant: SELECT "Manager" FROM "Table" WHERE "Club" = 'St. Johnstone';