Question d’entretien chez Lloyds Banking Group

Explain an SQL query, specifically a join