Citibank interview question

Questions regarding sql queries and joining tables