American Express Interview Question

Case study- fraudulent transactions detection SQL question- self join, aggregation and window functions