Show all publishers which do not have a book in 1989.
CREATE TABLE book_club (publisher VARCHAR, YEAR VARCHAR)
SELECT publisher FROM book_club EXCEPT SELECT publisher FROM book_club WHERE YEAR = 1989
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE book_club (publisher VARCHAR, YEAR VARCHAR) Question: Show all publishers which do not have a book in 1989. [/INST] SELECT publisher FROM book_club EXCEPT SELECT publisher FROM book_club WHERE YEAR = 1989 </s>