CREATE TABLE table_24302700_6 (name VARCHAR, nationality VARCHAR)

Who are all the players from the united states?
SELECT name FROM table_24302700_6 WHERE nationality = "United States"
SELECT "name" FROM "table_24302700_6" WHERE "United States" = "nationality"