Deutsche Bank Interview Question

Any filter formula to be explained