Barclays Interview Question

Basics on SQL join commands