Informatica interview question

SQL query (aggregate function, join queries)