Informatica Interview Question

SQL queries-Moderate difficulty