Show every author with the number of distinct books they wrote, including authors with no rows in the join table. Order by book count, highest first, then by name.
answer.sql is a query an assistant might well write. Read it first, then run it and compare with the expected result below. Fix it so every author is there.
Expected once fixed: 7 rows. Rowan Byrne is there with 0, Georgi Gospodinov has 3 books and Yoko Tawada has 2. The shipped file returns 6 rows.