Question d’entretien chez American Express

Asked to write a SQL with max , group by query