Amdocs interview question

SQL queries ...sub query and joins