CREATE TABLE pilot_record (record_id DECIMAL, pilot_id DECIMAL, aircraft_id DECIMAL, date TEXT)
CREATE TABLE pilot (pilot_id DECIMAL, pilot_name TEXT, rank DECIMAL, age DECIMAL, nationality TEXT, position TEXT, join_year DECIMAL, team TEXT)
CREATE TABLE aircraft (aircraft_id DECIMAL, order_year DECIMAL, manufacturer TEXT, model TEXT, fleet_series TEXT, powertrain TEXT, fuel_propulsion TEXT)

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