CREATE TABLE table_2897457_5 (nationality VARCHAR2, player VARCHAR2)

What nationality is keith carney?
SELECT nationality FROM table_2897457_5 WHERE player = "Keith Carney"
SELECT "nationality" FROM "table_2897457_5" WHERE "Keith Carney" = "player"