Question d’entretien chez MSCI

Given a table, asked to use left inner join