Informatica interview question

SQL queries-Moderate difficulty