Show the players and years played for players from team "Columbus Crew".
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"
What is Hong's singles record?
select singles_wl from player where player like "%hong%"