Happen Bank interview question

Fairly straightforward SQL assessment, requiring intermediate level aggregation and joins