Question · SQL and MySQL course · Module 8: Subqueries

Authors with no books

Which query returns authors who do NOT have any book?

Answer options

  • SELECT * FROM autorzy WHERE EXISTS (SELECT 1 FROM ksiazki);
  • SELECT * FROM autorzy WHERE ksiazki IS NULL;
  • SELECT * FROM autorzy WHERE NOT EXISTS (SELECT 1 FROM ksiazki WHERE ksiazki.autor_id = autorzy.id);
  • SELECT * FROM autorzy WHERE NOT IN ksiazki;

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