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