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