Coding task · SQL and MySQL course · Module 7: Joining tables (JOIN)
Title, author and year of publication
Extend the join of ksiazki with autorzy by an extra column from the books shelf.
Task
Write a query that shows the tytul of a book, the author's nazwisko and the book's rok_wydania. Join ksiazki (alias k) with autorzy (alias a) using INNER JOIN on k.autor_id = a.id.