Coding task · SQL and MySQL course · Module 2: Querying data (SELECT)

The masterful report

Bring together column selection, aliases, sorting and LIMIT in one query.

Task

Write a query that retrieves tytul with the alias Tytul and rok_wydania from the ksiazki table, sorts descending by year of publication and shows the 10 newest books.