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

Title, category and price

Join books with categories, showing title, category and price.

Task

Write a query that shows the book's tytul, the category name (nazwa) and the book's cena. Join ksiazki (alias k) with kategorie (alias kat) using INNER JOIN on k.kategoria_id = kat.id.