CREATE TABLE book (book_id DECIMAL, title TEXT, issues DECIMAL, writer TEXT)
CREATE TABLE publication (publication_id DECIMAL, book_id DECIMAL, publisher TEXT, publication_date TEXT, price DECIMAL)

List the titles of books that are not published.
SELECT title FROM book WHERE NOT book_id IN (SELECT book_id FROM publication)
SELECT "title" FROM "book" WHERE NOT "book_id" IN (SELECT "book_id" FROM "publication")