UnitedHealth Group Interview Question

Explain Left outer join with the case and query