Database: aan_1
Question: List the names of all authors and their number of papers in descending order by number of papers.
SQL:
SELECT T1.name ,  count(*) FROM Author AS T1 JOIN Author_list AS T2 ON T1.author_id  =  T2.author_id GROUP BY T1.author_id ORDER BY count(*) DESC