Show the pilot positions that have both pilots joining after year 2005 and pilots joining before 2000.
CREATE TABLE pilot (POSITION VARCHAR, Join_Year INTEGER)
SELECT POSITION FROM pilot WHERE Join_Year < 2000 INTERSECT SELECT POSITION FROM pilot WHERE Join_Year > 2005
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE pilot (POSITION VARCHAR, Join_Year INTEGER) Question: Show the pilot positions that have both pilots joining after year 2005 and pilots joining before 2000. [/INST] SELECT POSITION FROM pilot WHERE Join_Year < 2000 INTERSECT SELECT POSITION FROM pilot WHERE Join_Year > 2005 </s>