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.