Question

I need to find all the airplanes that can be used from bonn to madras.

Answer 1

I need to first find all the airplanes with cruising range greater than the distance between bonn and madras

Answer 2

to get the distance between bonn and madras I'll find an airplane that flew from bonn to madras and get their distance

Answer 3

Can't you just look up distance from Bonn to chennai: 7699 km

Answer 4

select schema aid (select rows cruisingrange>=distance( select schema distance ( (select rows from = madras, to=bonn (Aircraft)) union (select rows from=bonn,from=madras (Aircraft ) X Aircraft ) )

Answer 5

nope I have to do this instead