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.