SELECT 1 + 2 FROM opensearch_dashboards_sample_data_flights
SELECT Cancelled, AvgTicketPrice, FlightDelayMin, Carrier, timestamp FROM opensearch_dashboards_sample_data_flights
SELECT `Cancelled`, `AvgTicketPrice` FROM opensearch_dashboards_sample_data_flights
SELECT ABS(DistanceMiles), (FlightDelayMin * 2) - 3 FROM opensearch_dashboards_sample_data_flights
SELECT abs(DistanceMiles), Abs(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights
SELECT Cancelled AS Cancel, AvgTicketPrice AS ATP FROM opensearch_dashboards_sample_data_flights
SELECT Cancelled AS `Cancel` FROM opensearch_dashboards_sample_data_flights
SELECT opensearch_dashboards_sample_data_flights.AvgTicketPrice FROM opensearch_dashboards_sample_data_flights
SELECT flights.AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights flights
SELECT flights.AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights AS flights
SELECT opensearch_dashboards_sample_data_flights.AvgTicketPrice AS price FROM opensearch_dashboards_sample_data_flights WHERE opensearch_dashboards_sample_data_flights.AvgTicketPrice > 500
SELECT flights.AvgTicketPrice AS price, Carrier AS car FROM opensearch_dashboards_sample_data_flights AS flights WHERE flights.AvgTicketPrice > 500
SELECT `opensearch_dashboards_sample_data_flights`.`AvgTicketPrice` FROM opensearch_dashboards_sample_data_flights WHERE `opensearch_dashboards_sample_data_flights`.`AvgTicketPrice` <= 500
SELECT `flights`.`AvgTicketPrice`, `Carrier` FROM opensearch_dashboards_sample_data_flights AS flights WHERE `flights`.`AvgTicketPrice` <= 500
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE AvgTicketPrice <= 500
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE NOT AvgTicketPrice <= 500
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE AvgTicketPrice <= 500 AND FlightDelayMin = 0
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE AvgTicketPrice <= 500 OR FlightDelayMin = 0
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE AvgTicketPrice + 100 <= 500
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE ABS(AvgTicketPrice * -2) > 1000
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE Carrier LIKE 'JetBeat_'
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE Carrier LIKE '%Air%'
SELECT ALL OriginWeather FROM opensearch_dashboards_sample_data_flights
SELECT DISTINCT OriginWeather FROM opensearch_dashboards_sample_data_flights
SELECT DISTINCT OriginWeather, FlightDelay FROM opensearch_dashboards_sample_data_flights
SELECT DISTINCT SUBSTRING(OriginWeather, 1, 1) AS origin FROM opensearch_dashboards_sample_data_flights
SELECT DISTINCT SUBSTRING(OriginWeather, 1, 1) AS origin, FlightDelay FROM opensearch_dashboards_sample_data_flights
SELECT COUNT(*) AS count FROM opensearch_dashboards_sample_data_flights
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights ORDER BY AvgTicketPrice LIMIT 10
SELECT AvgTicketPrice FROM opensearch_dashboards_sample_data_flights ORDER BY AvgTicketPrice LIMIT 100
SELECT AvgTicketPrice FROM opensearch_dashboards_sample_data_flights ORDER BY AvgTicketPrice LIMIT 0
SELECT AvgTicketPrice FROM opensearch_dashboards_sample_data_flights ORDER BY AvgTicketPrice LIMIT 10 OFFSET 5
SELECT AvgTicketPrice FROM opensearch_dashboards_sample_data_flights ORDER BY AvgTicketPrice LIMIT 10 OFFSET 100
SELECT AvgTicketPrice FROM opensearch_dashboards_sample_data_flights ORDER BY AvgTicketPrice LIMIT 1000 OFFSET 100
SELECT abs(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights ORDER BY abs(AvgTicketPrice) LIMIT 10, 10
SELECT AvgTicketPrice - 1 FROM opensearch_dashboards_sample_data_flights ORDER BY AvgTicketPrice LIMIT 10, 10