Adyen Interview Question

a SQL question about select query with data filtering and group by