Amdocs Interview Question

sql quries on join condition , aggregate function , keys and constrains.