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

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions in PostgreSQL

When window functions are evaluated
Summary

Instruction

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

Exercise

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.