SELECT distinct L.FLT_NR "航班号",

                S.SCH_DEP_DT + 1 / 3 "起飞时间（北京时）",

                S.DEP_ARP_CD "起飞站",

                S.ARV_ARP_CD "落地站",

                S.LATEST_TAIL_NR "机尾号",

                C.FCAP "外籍机组"

  FROM (SELECT '3067' FLT_NR

          FROM DUAL

        UNION

        SELECT '0321'

          FROM DUAL

        UNION

        SELECT '0325'

          FROM DUAL

        UNION

        SELECT '0327'

          FROM DUAL

        UNION

        SELECT '0345'

          FROM DUAL

        UNION

        SELECT '0455'

          FROM DUAL

        UNION

        SELECT '0467'

          FROM DUAL

        UNION

        SELECT '0383'

          FROM DUAL

        UNION

        SELECT '0359'

          FROM DUAL

        UNION

        SELECT '0301'

          FROM DUAL

        UNION

        SELECT '0302' FROM DUAL) L,

       (SELECT *

          FROM SCH_DOPS_SOFL S

         WHERE S.SCH_DEP_DT BETWEEN SYSDATE - 1 / 3 AND

               TRUNC(SYSDATE) - 1 / 3 + 1 + 11 / 24) S,

       (select s.flt_dt, a.flt_nr, s.flt_nr as back_flt_nr, s.latest_tail_nr

          from Sch_dops_sofl s,

               (select s.flt_nr,