Barclays Interview Question

Basic sql join related questions were asked.