Deloitte Interview Question

Inner and outer joins on sql