BNP Paribas interview question

Asked about joins and asked to write certain sql queries