BNP Paribas Interview Question

Left join, right join, inner join having