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

Title and category name

Use the kategoria_id cross-reference to join books with their thematic section.

Task

Write a query that shows the tytul of each book and the name of its category (the nazwa column). Join ksiazki (alias k) with kategorie (alias kat) using an INNER JOIN on k.kategoria_id = kat.id.