Lloyds Banking Group interview question

Explain an SQL query, specifically a join