Amdocs interview question

Sql join queries