Deutsche Bank interview question

Any filter formula to be explained