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

All categories with RIGHT JOIN

Keep all categories on the right side of the join, even if they have no books.

Task

Write a query that shows the category name (nazwa) and the book's tytul. Use RIGHT JOIN so that all categories are shown. Aliases: ksiazki k, kategorie kat, condition k.kategoria_id = kat.id.