Coding task · SQL and MySQL course · Module 8: Subqueries
Authors who have books
Use 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 the imie and nazwisko columns of those authors who have at least one book. Use EXISTS and a subquery referencing autorzy.id (ksiazki.autor_id = autorzy.id).