select Day_Id
,Day_In_Season
,Fst_Agc_Offc_Cd
,Fst_Agc_IATA_Cd
,Fst_Agc_Prnt_Offc_Cd
,Fst_Agc_Cty_Cd
,Fst_Agc_Rgn_Cd
,Fst_Agc_Cntry_Cd
,Fst_Agc_Own_Sys
,Pnr_Orig_Gds_Cd
,Carr_Cd
,Carr_Df_Ind
,Flt_Nbr
,Flt_Nbr_Sfx
,Flt_Rte_Cd
,Flt_Typ
,Opr_Carr_Cd
,a.Dpt_Airpt_Cd
,Dpt_Cty_Cd
,Dpt_Rgn_Cd
,Dpt_Cntry_Cd
,Dpt_Area_Cd
,a.Arrv_Airpt_Cd
,Arrv_Cty_Cd
,Arrv_Rgn_Cd
,Arrv_Cntry_Cd
,Arrv_Area_Cd
,Lcl_Dpt_Dt
,case when (a.cls_cd = 'C' or a.cls_cd = 'F' or a.sub_cls_cd = 'Y')
then '1'
else '0'
end Hig_Pric_Ind
,Grp_Ind
from schl_pnrd_daily a
group by Day_Id
,Day_In_Season
,Fst_Agc_Offc_Cd
,Fst_Agc_IATA_Cd
,Fst_Agc_Prnt_Offc_Cd
,Fst_Agc_Cty_Cd
,Fst_Agc_Rgn_Cd
,Fst_Agc_Cntry_Cd
,Fst_Agc_Own_Sys
,Pnr_Orig_Gds_Cd
,Carr_Cd
,Carr_Df_Ind
,Flt_Nbr
,Flt_Nbr_Sfx
,Flt_Rte_Cd
,Flt_Typ
,Opr_Carr_Cd
,a.Dpt_Airpt_Cd
,Dpt_Cty_Cd
,Dpt_Rgn_Cd
,Dpt_Cntry_Cd
,Dpt_Area_Cd
,a.Arrv_Airpt_Cd
,Arrv_Cty_Cd
,Arrv_Rgn_Cd
,Arrv_Cntry_Cd
,Arrv_Area_Cd
,Lcl_Dpt_Dt
,Hig_Pric_Ind
,Grp_Ind;
ORA-00904: "HIG_PRIC_IND": 无效的标识符 |