Best April deals - hours only!Up to 80% off on all courses and bundles.-Close
When window functions are evaluated
Window functions and GROUP BY
Summary

## Instruction

Fine. Let's do one more exercise of this kind.

## Exercise

Group the auctions based on the day they ended and show the following columns: ended, the average number of views from auctions on that day and the ranking based on that average (the highest average should get the rank of 1).

### Stuck? Here's a hint!

Use

RANK() OVER(ORDER BY AVG(views) DESC