CREATE TABLE table_name_5 (team VARCHAR2, captain VARCHAR2)

On which team was Robbie Earle the captain?
SELECT team FROM table_name_5 WHERE captain = "robbie earle"
SELECT "team" FROM "table_name_5" WHERE "captain" = "robbie earle"