SELECT Title FROM book WHERE Book_ID NOT IN (SELECT Book_ID FROM publication)
List the titles of books that are not published.
SELECT Title FROM book WHERE Book_ID NOT IN ( SELECT Book_ID FROM publication )
select title from book where book_id not in ( select book_id from publication )
List the titles of books that are not published .