CREATE TABLE table_name_34 (captain VARCHAR2, manager VARCHAR2)

Which captain has billy bonds as the manager?
SELECT captain FROM table_name_34 WHERE manager = "billy bonds"
SELECT "captain" FROM "table_name_34" WHERE "billy bonds" = "manager"