Question · SQL and MySQL course · Module 7: Joining tables (JOIN)

The IS NULL filter after LEFT JOIN

Why do we add WHERE w.id IS NULL to the query czytelnicy c LEFT JOIN wypozyczenia w?

Answer options

  • To sort the result by the id column
  • To show only readers with many loans
  • To keep only readers without any loan (an empty match)
  • To remove the id column from the result

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