Database: book_press
Question: Find the names of authors who have more than one book in the database.
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