SELECT COUNT(FlightNum) FROM opensearch_dashboards_sample_data_flights GROUP BY FlightDelay ORDER BY COUNT(FlightNum)
SELECT COUNT(FlightNum) AS cnt FROM opensearch_dashboards_sample_data_flights GROUP BY FlightDelay ORDER BY cnt
SELECT COUNT(FlightNum) FROM opensearch_dashboards_sample_data_flights GROUP BY FlightDelay ORDER BY 1
SELECT OriginWeather, AVG(FlightTimeMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginWeather ORDER BY AVG(FlightTimeMin)
SELECT OriginWeather, AVG(FlightTimeMin), SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginWeather ORDER BY AVG(FlightTimeMin), SUM(FlightDelayMin)
SELECT OriginWeather, AVG(FlightTimeMin), SUM(FlightDelayMin) AS s FROM opensearch_dashboards_sample_data_flights GROUP BY OriginWeather ORDER BY AVG(FlightTimeMin), s
SELECT OriginWeather, AVG(FlightTimeMin) AS a, SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginWeather ORDER BY a, SUM(FlightDelayMin)