Coding task · SQL and MySQL course · Module 7: Joining tables (JOIN)
Title and author's surname
Join the shelf of books with the shelf of authors using INNER JOIN, following the autor_id cross-reference.
Task
Write a query that, for each book, shows its tytul and the author's nazwisko. Join the tables ksiazki (alias k) and autorzy (alias a) with an INNER JOIN, matching k.autor_id to a.id.