Coding task · SQL and MySQL course · Module 7: Joining tables (JOIN)

All authors, even without books

Use RIGHT JOIN to keep all authors, even those whose books are not yet on the shelf.

Task

Write a query that shows the author's nazwisko and the tytul of their book. Use RIGHT JOIN so that authors with no book are shown too. Aliases: ksiazki k, autorzy a, condition k.autor_id = a.id.