CREATE TABLE book (book_id NUMBER, title CLOB, issues NUMBER, writer CLOB)
CREATE TABLE publication (publication_id NUMBER, book_id NUMBER, publisher CLOB, publication_date CLOB, price NUMBER)

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")