State Street Interview Question

Inner joins and outer join explanation using table.