Amdocs Interview Question

SQL queries ...sub query and joins