Write a query to print the author IDs of authors who wrote books in 5 or more genres.
Asked in the phone screen stage. Use the authors, books, and book_genres tables.
author_id.author_id in ascending order.| Column | Type | Description |
|---|---|---|
| author_idPK | INT | Unique identifier for an author |
| Column | Type | Description |
|---|---|---|
| book_idPK | INT | Unique identifier for a book |
| author_id | INT | Author who wrote the book |
| book_title | VARCHAR(200) | Title of the book |
| Column | Type | Description |
|---|---|---|
| book_id | INT | Book assigned to the genre |
| genre_name | VARCHAR(100) | Genre assigned to the book |