Equinox Gold Interview Question

Explain left join? Explain inner query?