SELECT COUNT(*) FROM opensearch_dashboards_sample_data_flights
SELECT COUNT(1) FROM opensearch_dashboards_sample_data_flights
SELECT COUNT('hello') FROM opensearch_dashboards_sample_data_flights
SELECT SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights
SELECT AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights
SELECT MIN(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights
SELECT MAX(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights
SELECT count(*), Avg(FlightDelayMin), sUm(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights
SELECT COUNT(*) AS cnt, AVG(FlightDelayMin) AS a, SUM(FlightDelayMin) AS s FROM opensearch_dashboards_sample_data_flights
SELECT COUNT(*) FROM opensearch_dashboards_sample_data_flights WHERE FlightTimeMin > 0
SELECT COUNT(1) FROM opensearch_dashboards_sample_data_flights WHERE FlightTimeMin > 0
SELECT SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights WHERE FlightTimeMin > 0
SELECT AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights WHERE FlightTimeMin > 0
SELECT COUNT(*) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT COUNT(FlightNum) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT COUNT(FlightDelay) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT COUNT(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT OriginCountry, COUNT(*) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT OriginCountry, ABS(COUNT(*)) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT OriginCountry, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT OriginCountry, SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT OriginCountry, AVG(FlightDelayMin) + SUM(FlightDelayMin) as Total FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT OriginCountry, COUNT(*), AVG(FlightDelayMin), SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry
SELECT COUNT(*), AVG(FlightDelayMin), SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry, OriginCityName
SELECT OriginCountry, COUNT(*), AVG(FlightDelayMin), SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry, OriginCityName
SELECT OriginCountry, OriginCityName, COUNT(*) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry, OriginCityName
SELECT OriginCountry, OriginCityName, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry, OriginCityName
SELECT OriginCountry, OriginCityName, SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry, OriginCityName
SELECT AvgTicketPrice, COUNT(*), AVG(AvgTicketPrice), SUM(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights GROUP BY AvgTicketPrice
SELECT ABS(AvgTicketPrice), COUNT(*), AVG(AvgTicketPrice), SUM(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights GROUP BY AvgTicketPrice
SELECT FlightDelayMin, COUNT(*), AVG(FlightDelayMin), SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY FlightDelayMin
SELECT OriginCountry, OriginCityName, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY 1, 2
SELECT OriginCountry, OriginCityName, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry, 2
SELECT OriginCountry, OriginCityName, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY 1, OriginCityName
SELECT ABS(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY 1
SELECT OriginCountry AS country, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY country
SELECT OriginCountry AS country, OriginCityName, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY country, 2
SELECT OriginCountry AS country, OriginCityName AS city, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY country, city
SELECT ABS(FlightDelayMin) AS delay FROM opensearch_dashboards_sample_data_flights GROUP BY delay
SELECT flights.OriginCountry, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights AS flights GROUP BY flights.OriginCountry
SELECT flights.OriginCountry, flights.OriginCityName, SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights AS flights GROUP BY flights.OriginCountry, flights.OriginCityName
SELECT flights.OriginCountry, flights.OriginCityName, SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights AS flights GROUP BY 1, 2
SELECT flights.OriginCountry AS country, flights.OriginCityName AS city, SUM(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights AS flights GROUP BY country, city
SELECT ABS(flights.FlightDelayMin) AS delay FROM opensearch_dashboards_sample_data_flights AS flights GROUP BY delay
SELECT `flights`.OriginCountry, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights AS `flights` GROUP BY `flights`.OriginCountry
SELECT `flights`.OriginCountry, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights AS `flights` GROUP BY 1
SELECT 'This is not an empty index' FROM opensearch_dashboards_sample_data_flights HAVING COUNT(FlightNum) > 0
SELECT 'This is an empty index' FROM opensearch_dashboards_sample_data_flights HAVING COUNT(FlightNum) = 0
SELECT 'The average delay time > 10 min' FROM opensearch_dashboards_sample_data_flights HAVING AVG(FlightDelayMin) > 10
SELECT OriginCountry, COUNT(FlightNum) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry HAVING COUNT(FlightNum) > 1
SELECT OriginCountry, COUNT(FlightNum) AS cnt FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry HAVING cnt = 1
SELECT OriginCountry, COUNT(FlightNum) AS cnt FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry HAVING 1 < cnt
SELECT OriginCountry, COUNT(FlightNum) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry HAVING MIN(FlightDelayMin) > 100
SELECT OriginCountry, COUNT(FlightNum) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry HAVING COUNT(FlightNum) > 1 OR MIN(FlightDelayMin) > 100
SELECT OriginCountry, COUNT(FlightNum) FROM opensearch_dashboards_sample_data_flights GROUP BY OriginCountry HAVING COUNT(FlightNum) = 1 AND MIN(FlightDelayMin) <= 100