BNP Paribas Interview Question

Asked about joins and asked to write certain sql queries