Domanda di colloquio di Invesco

They gave one sql query based on group by ,order by and having clause.