Question

In a database containing information about books and authors, write an SQL query to identify the author with the most published books.

Answer 1

SELECT author_id, author_name, COUNT(book_id) AS total_books

FROM Authors

JOIN Books ON Authors.author_id = Books.author_id

GROUP BY author_id, author_name

ORDER BY total_books DESC

FETCH FIRST 1 ROWS ONLY;