SELECT PP.LAST_NAME        员工姓名,
       PP.PERSON_ID        员工ID,
       PP.SEX              性别,
       PP.EMAIL_ADDRESS　  电子邮件,
       PPF.LAST_NAME　     主管姓名,
       PPF.EMAIL_ADDRESS　 主管EMAIL
  FROM PER_PEOPLE_F PP, PER_ASSIGNMENTS_F PA, PER_PEOPLE_F PPF
 WHERE PP.PERSON_ID = PA.PERSON_ID
   AND SYSDATE BETWEEN PA.EFFECTIVE_START_DATE AND PA.EFFECTIVE_END_DATE
   AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND PP.EFFECTIVE_END_DATE
   AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE
   AND PA.SUPERVISOR_ID = PPF.PERSON_ID
   ORDER BY PP.CREATION_DATE ASC;