SELECT Origin, SUM(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights GROUP BY Origin SELECT Dest, AVG(FlightTimeMin) FROM opensearch_dashboards_sample_data_flights GROUP BY Dest