Infosys Interview Question

Can you explain the differences between SQL joins such as INNER JOIN, LEFT JOIN, and RIGHT JOIN, and provide a real-time example where each join type would be used?