Barclays interview question

Basic sql join related questions were asked.