Identify authors who have published at least 5 books within a specific catalog database.
Write a SQL query using the books table. Count books for each non-null author and return only authors meeting the minimum count.
author_name and book_countbook_count descending, then author_name ascending| Column | Type | Description |
|---|---|---|
| book_idPK | INT | Unique identifier for the catalog book |
| author_name | VARCHAR(150) | Name of the book's author |
| title | VARCHAR(255) | Catalog title of the book |
| published_year | INT | Year the book was published |