CREATE TABLE table_name_53 (manager VARCHAR2, club VARCHAR2)

Who is the manager of the St. Johnstone club?
SELECT manager FROM table_name_53 WHERE club = "st. johnstone"
SELECT "manager" FROM "table_name_53" WHERE "club" = "st. johnstone"