Pregunta de entrevista de Happen Bank

Fairly straightforward SQL assessment, requiring intermediate level aggregation and joins