Database: book_press
Question: Which authors have published more than 1 book according to the database? Give me their names.
SQL:
SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id GROUP BY t2.author_id HAVING count(*)  >  1