Pregunta de entrevista de UnitedHealth Group

Explain Left outer join with the case and query