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.