CREATE TABLE pilot (POSITION VARCHAR, Join_Year INT)

Show the pilot positions that have both pilots joining after year 2005 and pilots joining before 2000.
SELECT POSITION FROM pilot WHERE Join_Year < 2000 INTERSECT SELECT POSITION FROM pilot WHERE Join_Year > 2005
SELECT "POSITION" FROM "pilot" WHERE "Join_Year" < 2000 INTERSECT SELECT "POSITION" FROM "pilot" WHERE "Join_Year" > 2005