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.