What are the departure dates for all flights from Los Angeles to Honolulu?
select departure_date from flight where origin = "Los Angeles" and destination = "Honolulu"
What are the arrival dates for all flights from Los Angeles to Honolulu?
select arrival_date from flight where origin = "Los Angeles" and destination = "Honolulu"
What are the prices of those flights?
select price from flight where origin = "Los Angeles" and destination = "Honolulu"
What about the flight numbers?
select flno from flight where origin = "Los Angeles" and destination = "Honolulu"