Coding task · SQL and MySQL course · Module 7: Joining tables (JOIN)
Title, author and author's country
The last exercise on the bridge - join a book with its author and show the creator's country of origin.
Task
Write a query that shows the book's tytul, the author's nazwisko and their kraj. Join ksiazki (alias k) with autorzy (alias a) using INNER JOIN on k.autor_id = a.id.