What is the average price for flights from LA to Honolulu?
SELECT avg(price) FROM Flight WHERE origin  =  "Los Angeles" AND destination  =  "Honolulu"
average price refers to AVG(price); flights from LA to Honolulu refers to flights where origin = 'Los Angeles' and destination = 'Honolulu';