Question d’entretien chez Revolut

Write an SQL query with aggregation.