Show the price for all flights.
select price from flight
How about those from Los Angeles to Honolulu?
select price from flight where origin = "Los Angeles" and destination = "Honolulu"
What is the average of them?
select avg(price) from flight where origin = "Los Angeles" and destination = "Honolulu"