Oracle8i 数据库，SQL语句如下：
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,
s.latest_tail_nr,
s.sch_dep_dt,