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