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.