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.