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

Authors from the same country

Join the autorzy table with itself (self-join) to pair up creators from the same country.

Task

Write a query that shows the surnames of pairs of authors who come from the same country. Join autorzy a1 with autorzy a2 using INNER JOIN on a1.kraj = a2.kraj. Select a1.nazwisko and a2.nazwisko.