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).