Database: aan_1
Question: What are the names of authors who have exactly 1 paper?
SQL:
SELECT T1.name FROM Author AS T1 JOIN Author_list AS T2 ON T1.author_id  =  T2.author_id GROUP BY T1.author_id HAVING count(*)  =  1