Amdocs Interview Question

Related to Joins in SQL and one coding problem on String.