Amdocs Interview Question

SQL query using join.