Explain the practical differences between an INNER JOIN, a LEFT JOIN, and a CROSS JOIN, and provide a scenario where you would use each.