Put in order · SQL and MySQL course · Module 7: Joining tables (JOIN)

Following the foreign keys

Arrange the steps of following foreign keys to get from a loan to the surname of the borrowed book's author:

Items to put in order

  • wypozyczenia.ksiazka_id points to ksiazki.id
  • autorzy.nazwisko is the surname you want
  • ksiazki.autor_id points to autorzy.id

You can check the correct answer by solving this task in the CodeWorlds game.