Create aggregate queries using GROUP BY and using analytic functions

Showing the single result