航班信息查询：2022年1月1日至3日航班数据

SELECT CONCAT(airlines_cd, fit_no) AS flight_number, TIMEDIFF(fit_act_tm, fit_sch_tm) AS flight_duration, airline_fullname AS flight_route FROM f_flight_info WHERE fit_sch_tm >= '2022-01-01' AND fit_sch_tm <= '2022-01-03' ORDER BY fit_sch_tm DESC