Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Evaluation Order and Common Problems
Window functions and GROUP BY
Summary and Review


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 – A unique ID for each auction
  • CategoryId – An ID of the type of auction, e.g. furniture, medical supplies, etc.
  • AskingPrice – The initial price set by the seller
  • FinalPrice – The highest bid paid to the seller
  • Views – The number of views for that auction
  • Participants – The number of users who took part in that auction
  • Country – The country of that auction
  • EndDate – When the auction ended and the item was sold