Question d’entretien chez UnitedHealth Group

Explain Left outer join with the case and query