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.