When window functions are evaluated
Window functions and GROUP BY


In this part, we'll keep things simple by only working with a single table - auction. Let's get to know it.


Select all columns from the auction table.

The table stores information about past Internet auctions from a certain online auction website. You can see the following columns:

  • id - unique id of the auction,
  • category_id - id of the category, like: furniture, health etc.,
  • asking_price - the initial price set by the seller,
  • final_price - the highest bid, paid to the seller,
  • views - number of views of the auction on the website,
  • participants - number of users who took part in the auction,
  • country - country of the auction,
  • ended - the day on which the auction ended and the item was sold.


Code editor