Books With Author and Publisher

Problem

Write a query that returns each book's title, its author's name (aliased as author_name), and its publisher's name (aliased as publisher_name), joining books to both authors and publishers, filtered to books published after the year 2010. Order the results by published_year from newest to oldest.

Try It

Hint

Solution