Pregunta de entrevista de Barclays

Basic sql join related questions were asked.