Coding task · SQL and MySQL course · Module 10: Transactions and advanced SQL

Numbering readers

Practice the window function on the readers shelf - number them by sign-up date.

Task

Write a query that retrieves imie and nazwisko from the czytelnicy table, and additionally adds a column aliased as numer containing the result of ROW_NUMBER() OVER (ORDER BY data_zapisu).