When window functions are evaluated
Window functions and GROUP BY
Summary
19. Table book

Instruction

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

Exercise

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.

Console

Code editor

Result

TableConsole