Query to find authors who have written more than 10 books

• Use the GROUP BY clause to group the records by author

• Use the HAVING clause to filter the groups with a count greater than 10

• Join the Bookautho...read more

SELECT Author, COUNT(Book) AS NumBooks

FROM BookAuthor

GROUP BY Author

HAVING NumBooks > 10;

SELECT Author,(COUNT(Author))AS QTY FROM Bookauthhor Group By Author Having QTY > 5;

SELECT Author.name

FROM Book

JOIN Bookauthor ON Book.book_id = Bookauthor.book_id

JOIN Author ON Bookauthor.author_id = Author.author_id

GROUP BY Author.author_id, Author.name

HAVING COUNT(*) > 10;