Accenture interview question

Basic SQL ( Left Join )