List all the coaches with more game lost than won from year 2000-2010. List the coach ID, team name and year.
from year 2000 to 2010 refers to year between 2000 and 2010; more game lost then won refers to lost > won
SELECT DISTINCT T1.coachID, T2.tmID, T1.year FROM coaches AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID AND T1.year = T2.year WHERE T1.year BETWEEN 2000 AND 2010 AND T2.lost > T2.won