Coding task · SQL and MySQL course · Module 8: Subqueries

Authors with no books

Use NOT EXISTS with a correlated subquery that checks whether a book by the given author exists.

Task

Write a query that retrieves from the autorzy table (alias a) all columns of those authors who have no book at all. Use NOT EXISTS and a subquery referencing a.id (k.autor_id = a.id), where ksiazki has the alias k.