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


In order to test your knowledge, we'll use a very simple table called book. Let's check its contents.


Select all columns from the book table.

Each book has its own id, the id of its author, publication year in the publish_year column, a certain price and a rating from 0 to 10.