Barclays interview question

Basics on SQL join commands