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)

Show the publishers that have publications with price higher than 10000000 and publications with price lower than 5000000.
SELECT publisher FROM publication WHERE price > 10000000 INTERSECT SELECT publisher FROM publication WHERE price < 5000000
SELECT "publisher" FROM "publication" WHERE "price" > 10000000 INTERSECT SELECT "publisher" FROM "publication" WHERE "price" < 5000000