Database: book_1
Question: What are the names of all the authors, and how many books has each written?
SQL:
SELECT T1.name ,  count(*) FROM Author AS T1 JOIN Author_Book AS T2 ON T1.idAuthor  =  T2.Author GROUP BY T1.idAuthor