CREATE TABLE player (player_id DECIMAL, player TEXT, years_played TEXT, total_wl TEXT, singles_wl TEXT, doubles_wl TEXT, team DECIMAL)
CREATE TABLE match_season (season DECIMAL, player TEXT, position TEXT, country DECIMAL, team DECIMAL, draft_pick_number DECIMAL, draft_class TEXT, college TEXT)
CREATE TABLE team (team_id DECIMAL, name TEXT)
CREATE TABLE country (country_id DECIMAL, country_name TEXT, capital TEXT, official_native_language TEXT)

What are the players who played for Columbus Crew, and how many years did each play for?
SELECT T1.player, T1.years_played FROM player AS T1 JOIN team AS T2 ON T1.team = T2.team_id WHERE T2.name = "Columbus Crew"
SELECT "T1"."player", "T1"."years_played" FROM "player" AS "T1" JOIN "team" AS "T2" ON "Columbus Crew" = "T2"."name" AND "T1"."team" = "T2"."team_id"