Informatica Interview Question

sql queries on joins.