Lloyds Banking Group Interview Question

Explain an SQL query, specifically a join