When window functions are evaluated
Window functions and GROUP BY
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.
