Skip to content
SQLSimplified
mediumlibraryjoingroup-bycount

Books Per Author

Problem

Return each author's name and the number of books they wrote, ordered by book_count descending.

Try It

Library (Books/Authors/Publishers)

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems