what is the date of first flight?
select date from flight order by date limit 1
who is the first flight's pilot?
select pilot from flight order by date limit 1
what is the average of altitude?
select avg ( altitude ) from flight