Happen Bank Interview Question

Fairly straightforward SQL assessment, requiring intermediate level aggregation and joins