What is the title and director for the movie with highest worldwide gross in the year 2000 or before?
CREATE TABLE movie (title VARCHAR, director VARCHAR, YEAR VARCHAR, gross_worldwide VARCHAR)
SELECT TOP 1 title, director FROM movie WHERE YEAR <= 2000 ORDER BY gross_worldwide DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE movie (title VARCHAR, director VARCHAR, YEAR VARCHAR, gross_worldwide VARCHAR) Question: What is the title and director for the movie with highest worldwide gross in the year 2000 or before? [/INST] SELECT TOP 1 title, director FROM movie WHERE YEAR <= 2000 ORDER BY gross_worldwide DESC </s>