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
pilots joining after year 2005 refers to Join_Year > 2005; pilots joining before year 2000 refers to Join_Year < 2000; both conditions met refers to INTERSECT between two SELECT queries;