Find the book code and book title for each book whose price is more than $10 but that was NOT published in Boston.

SELECT BOOK.BOOK_CODE, BOOK.TITLE
FROM BOOK
WHERE PRICE > '10'
MINUS
SELECT BOOK.BOOK_CODE, BOOK.TITLE
FROM BOOK, PUBLISHER
WHERE BOOK.PUBLISHER_CODE = PUBLISHER.PUBLISHER_CODE
AND PUBLISHER.CITY = 'BOSTON';

Find the book code and book title for each book whose price is more than $10 and that was published in Boston.

SELECT BOOK.BOOK_CODE, BOOK.TITLE
FROM BOOK
WHERE PRICE > '10'
INTERSECT
SELECT BOOK_CODE, TITLE
FROM BOOK, PUBLISHER
WHERE PUBLISHER.CITY = 'BOSTON'
AND BOOK.PUBLISHER_CODE = PUBLISHER.PUBLISHER_CODE;