Put in order · SQL and MySQL course · Module 7: Joining tables (JOIN)
A full self-join of the autorzy table
Arrange the parts of a self-join of the autorzy table (top to bottom):
Items to put in order
- FROM autorzy a1
- SELECT a1.nazwisko, a2.nazwisko
- ON a1.kraj = a2.kraj;
- INNER JOIN autorzy a2
You can check the correct answer by solving this task in the CodeWorlds game.