MSCI Interview Question

Given a table, asked to use left inner join