State Street interview question

Inner joins and outer join explanation using table.