Coding task · SQL and MySQL course · Module 8: Subqueries

The newest book

Use a scalar subquery with the MAX function to find the book with the latest year of publication.

Task

Write a query that retrieves from the ksiazki table the tytul column of those books whose rok_wydania equals the greatest year of publication (MAX) in the table. Compute the maximum in a subquery.