American Express Interview Question

Asked to write a SQL with max , group by query