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.