EXL Service interview question

SQL Joins, Correlated Sub Queries