Impetus Technologies Interview Question

SQL queries on join