Cred | OA | 28 Nov, 2025 | SQL Coding: Transactions Monitoring

Question: Transactions Monitoring Companies Report Problem Statement: For HackerPay's billing analytics, a team needs a list of sender IBAN codes that are under monitoring and participate in 2 or more completed transactions within any 24 hour window. A completed transaction is one where completed = "yes". The output should be in the following format: sender, sequence_lengths, sequence_total. sender is the IBAN code. sequence_lengths is a comma-separated list of sequences length for a particular IBAN code, ordered by sequence length descending. ...