HSBC interview question

SQL join queries were asked