American Express interview question

Asked to write a SQL with max , group by query