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

Finding readers with no loans

Arrange the parts of a query that finds readers with no loans (top to bottom):

Items to put in order

  • SELECT c.nazwisko
  • WHERE w.id IS NULL;
  • LEFT JOIN wypozyczenia w ON w.czytelnik_id = c.id
  • FROM czytelnicy c

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