Amdocs interview question

SQL query using join.