Explain the difference between LEFT JOIN, INNER JOIN, and CROSS JOIN, and provide a scenario where you would use each at Lendbuzz.
