现表f_flight_info表中有字段fit_act_tm类型为datetime记录实际起飞和降落时间fit_sch_tm类型为datetime记录计划起飞和降落时间airlines_cd类型为char记录航空公司编码fit_no类型为char记录航班编号airline_fullname记录航班的航线例如：上海-江苏-重庆写出sql命令查询2022-01-01到2022-01-03之间的航班信息

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