text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  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.
  ### Answer:
  SELECT POSITION FROM pilot WHERE Join_Year < 2000 INTERSECT SELECT POSITION FROM pilot WHERE Join_Year > 2005