Amdocs interview question

Simple SQL operations mostly about joins