Subqueries
47.5
Exercise

Subqueries with multiple results

Write a query to display name and publisherName of all such books which are published by a publisher who have worked with at least 3 distinct authors (i.e. the total number of distinct authors who have written a book with that publisher are 3 or more). Set the respective headers as book and publisherName respectively.