如何使用SQL查询航班信息和旅客最大年龄

SELECT flight_num, ticket_left , count(*) ,min() FROM passenger p ,flightorder o , flight f WHERE f.fid=3 and f.fid=o.fid and o.pid = p.pid 根据身份证号来查旅客中最大的年龄内容：SELECT MAX(age) FROM passenger