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

Full book report

Join a book with its author and category, adding the year of publication.

Task

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