Pergunta de entrevista da empresa DatabaseUSA

"Explain the differences between INNER JOIN and LEFT JOIN in SQL. Provide a real-world scenario where you would use each type of join."