CASE
 WHEN te.TEAM_ID	LIKE 'MU%' THEN 'Manchester United'
 WHEN te.TEAM_ID	LIKE 'RM%' THEN 'Real Madrid'
END Team