Subqueries


SELECT  name AS book,
        publisherName
FROM    books
WHERE   publisherName IN  (
                            SELECT   publisherName
                            FROM     books JOIN authors
                            ON       books.authorId = authors.id
                            GROUP BY publisherName
                            HAVING   COUNT(DISTINCT authors.id) >= 3   
                        )
