Barclays Interview Question

Write and explain a query using SQL JOINs, including INNER JOIN and LEFT JOIN.