Intel Corporation interview question

SQL queries: 1. Basic JOIN 2. Use case for LEFT JOIN, RIGHT JOIN, INNER JOIN