Informatica interview question

sql queries on joins.