what was the destination of flight 99 ?
select destination from flight where flno = 99
How far did flight 99 fly ?
select distance from flight where flno = 99
What was the name of the airplane from flight 99 ?
select t2.name from flight as t1 join aircraft as t2 on t1.aid = t2.aid where t1.flno = 99