Barclays interview question

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

Barclays Interview Question: Write and explain a query using SQL JOINs, including INNER JOIN and LEFT JOIN. | Glassdoor