CREATE TABLE table_name_29 (manager VARCHAR, captain VARCHAR)

Which manager has Sol Campbell as captain?
SELECT manager FROM table_name_29 WHERE captain = "sol campbell"
SELECT "manager" FROM "table_name_29" WHERE "captain" = "sol campbell"