Show publishers with a book published in 1989 and a book in 1990.
CREATE TABLE book_club (publisher VARCHAR, YEAR VARCHAR)
SELECT publisher FROM book_club WHERE YEAR = 1989 INTERSECT SELECT publisher FROM book_club WHERE YEAR = 1990
<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 publishers with a book published in 1989 and a book in 1990. [/INST] SELECT publisher FROM book_club WHERE YEAR = 1989 INTERSECT SELECT publisher FROM book_club WHERE YEAR = 1990 </s>