Pergunta de entrevista da empresa Barclays

A query based on multiple joins including 4 tables. A coding question on array. A guesstimate.