Show the origin for all flights.
select origin from flight
How about those with a price higher than 300?
select origin from flight where price > 300
For each of them, also show the destination.
select origin, destination from flight where price > 300