Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
When window functions are evaluated


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_idid 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,
  • viewsnumber of views of the auction on the website,
  • participantsnumber of users who took part in the auction,
  • countrycountry of the auction,
  • endedthe day on which the auction ended and the item was sold.