Database: book_press
Question: Which authors in the record have not published any books ? Give me their names .
SQL:
select name from author where author_id not in (select author_id from book)