Pregunta de entrevista de Amdocs

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