which basketball coach has 47 career losses?
(AND basketball.basketball_coach (JOIN basketball.basketball_coach.season_losses 47^^http://www.w3.org/2001/XMLSchema#integer))