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.