Coding task · SQL and MySQL course · Module 8: Subqueries
Prolific authors
Use a correlated subquery that counts the current author's books and compare the result with a number.
Task
Write a query that retrieves from the autorzy table (alias a) the imie and nazwisko columns of those authors who have more than 3 books. Use a correlated COUNT(*) subquery on the ksiazki table (alias k), where the condition is k.autor_id = a.id.