SELECT AvgTicketPrice, Cancelled, Carrier, FlightDelayMin, timestamp FROM opensearch_dashboards_sample_data_flights
SELECT AvgTicketPrice AS avg, Cancelled AS cancel, Carrier AS carrier, FlightDelayMin AS delay, timestamp AS ts FROM opensearch_dashboards_sample_data_flights
SELECT f.AvgTicketPrice AS avg, f.Cancelled AS cancel, f.Carrier AS carrier, f.FlightDelayMin AS delay, timestamp AS ts FROM opensearch_dashboards_sample_data_flights f
SELECT LOG(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights
SELECT LOG2(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights
SELECT LOG10(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights
SELECT LN(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights
SELECT SQRT(DistanceMiles) FROM opensearch_dashboards_sample_data_flights
SELECT CBRT(DistanceMiles) FROM opensearch_dashboards_sample_data_flights
SELECT CEIL(FlightTimeMin) FROM opensearch_dashboards_sample_data_flights
SELECT FLOOR(FlightTimeMin) FROM opensearch_dashboards_sample_data_flights
SELECT SIN(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights
SELECT COS(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights
SELECT TAN(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights
SELECT ASIN(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights
SELECT ACOS(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights
SELECT ATAN(AvgTicketPrice) FROM opensearch_dashboards_sample_data_flights
SELECT LEFT(Origin, 3) FROM opensearch_dashboards_sample_data_flights
SELECT RIGHT(Origin, 3) FROM opensearch_dashboards_sample_data_flights
SELECT LENGTH(Origin) FROM opensearch_dashboards_sample_data_flights
SELECT ASCII(Origin) FROM opensearch_dashboards_sample_data_flights
SELECT TRIM(Origin) FROM opensearch_dashboards_sample_data_flights
SELECT LOWER(Origin) FROM opensearch_dashboards_sample_data_flights
SELECT UPPER(Origin) FROM opensearch_dashboards_sample_data_flights
SELECT SUBSTRING(Origin, 1, 5) FROM opensearch_dashboards_sample_data_flights
SELECT YEAR(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT MONTH(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT DAYOFMONTH(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT MONTH_OF_YEAR(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT WEEK_OF_YEAR(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT DAY_OF_YEAR(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT DAY_OF_MONTH(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT DAY_OF_WEEK(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT HOUR_OF_DAY(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT MINUTE_OF_DAY(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT MINUTE_OF_HOUR(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT SECOND_OF_MINUTE(timestamp) FROM opensearch_dashboards_sample_data_flights
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE AvgTicketPrice <= 500
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE AvgTicketPrice <= 500 AND Cancelled = False
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE timestamp > '2019-12-23 10:00:00'
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE opensearch_dashboards_sample_data_flights.Carrier LIKE 'Wind'
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE AvgTicketPrice <= 500 ORDER BY FlightDelayMin LIMIT 5
SELECT AvgTicketPrice, Carrier FROM opensearch_dashboards_sample_data_flights WHERE AvgTicketPrice <= 500 ORDER BY DestAirportID LIMIT 5
SELECT Carrier, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY Carrier
SELECT Carrier, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY 1
SELECT Carrier, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights WHERE FlightDelay = True GROUP BY Carrier
SELECT Carrier, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY Carrier HAVING AVG(FlightTimeMin) > 100
SELECT Carrier, MAX(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY Carrier HAVING AVG(FlightTimeMin) > 100
SELECT Carrier, AVG(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY Carrier ORDER BY Carrier LIMIT 2
SELECT AvgTicketPrice AS AvgTicketPrice, DestCountry AS DestCountry FROM opensearch_dashboards_sample_data_ecommerce e JOIN opensearch_dashboards_sample_data_flights f ON (e.day_of_week_i = f.dayOfWeek) LIMIT 1000
SELECT AvgTicketPrice AS AvgTicketPrice, DestCountry AS DestCountry FROM opensearch_dashboards_sample_data_ecommerce e LEFT JOIN opensearch_dashboards_sample_data_flights f ON (e.day_of_week_i = f.dayOfWeek) LIMIT 1000