Who is the author who wrote the most books?
author refers to author_name; who wrote the most book refers to Max(Count(author_id))
SELECT T1.author_name FROM author AS T1 INNER JOIN book_author AS T2 ON T1.author_id = T2.author_id GROUP BY T1.author_name ORDER BY COUNT(T2.author_id) DESC LIMIT 1