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)
CREATE TABLE player (player_id DECIMAL, player TEXT, years_played TEXT, total_wl TEXT, singles_wl TEXT, doubles_wl TEXT, team DECIMAL)

Who are the different players, what season do they play in, and what is the name of the team they are on?
SELECT T1.season, T1.player, T2.name FROM match_season AS T1 JOIN team AS T2 ON T1.team = T2.team_id
SELECT "T1"."season", "T1"."player", "T2"."name" FROM "match_season" AS "T1" JOIN "team" AS "T2" ON "T1"."team" = "T2"."team_id"