Barclays interview question

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