BNP Paribas interview question

Left join, right join, inner join having