forked from opendistro-for-elasticsearch/sql
-
Notifications
You must be signed in to change notification settings - Fork 0
/
select.txt
28 lines (28 loc) · 2.51 KB
/
select.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
SELECT 1 + 2 FROM kibana_sample_data_flights
SELECT Cancelled, AvgTicketPrice, FlightDelayMin, Carrier, timestamp FROM kibana_sample_data_flights
SELECT `Cancelled`, `AvgTicketPrice` FROM kibana_sample_data_flights
SELECT ABS(DistanceMiles), (FlightDelayMin * 2) - 3 FROM kibana_sample_data_flights
SELECT abs(DistanceMiles), Abs(FlightDelayMin) FROM kibana_sample_data_flights
SELECT Cancelled AS Cancel, AvgTicketPrice AS ATP FROM kibana_sample_data_flights
SELECT Cancelled AS `Cancel`, AvgTicketPrice AS "ATP" FROM kibana_sample_data_flights
SELECT kibana_sample_data_flights.AvgTicketPrice FROM kibana_sample_data_flights
SELECT flights.AvgTicketPrice, Carrier FROM kibana_sample_data_flights flights
SELECT flights.AvgTicketPrice, Carrier FROM kibana_sample_data_flights AS flights
SELECT kibana_sample_data_flights.AvgTicketPrice AS price FROM kibana_sample_data_flights WHERE kibana_sample_data_flights.AvgTicketPrice > 500
SELECT flights.AvgTicketPrice AS price, Carrier AS car FROM kibana_sample_data_flights AS flights WHERE flights.AvgTicketPrice > 500
SELECT `kibana_sample_data_flights`.`AvgTicketPrice` FROM kibana_sample_data_flights WHERE `kibana_sample_data_flights`.`AvgTicketPrice` <= 500
SELECT `flights`.`AvgTicketPrice`, `Carrier` FROM kibana_sample_data_flights AS flights WHERE `flights`.`AvgTicketPrice` <= 500
SELECT AvgTicketPrice, Carrier FROM kibana_sample_data_flights WHERE AvgTicketPrice <= 500
SELECT AvgTicketPrice, Carrier FROM kibana_sample_data_flights WHERE NOT AvgTicketPrice <= 500
SELECT AvgTicketPrice, Carrier FROM kibana_sample_data_flights WHERE AvgTicketPrice <= 500 AND FlightDelayMin = 0
SELECT AvgTicketPrice, Carrier FROM kibana_sample_data_flights WHERE AvgTicketPrice <= 500 OR FlightDelayMin = 0
SELECT AvgTicketPrice, Carrier FROM kibana_sample_data_flights WHERE AvgTicketPrice + 100 <= 500
SELECT AvgTicketPrice, Carrier FROM kibana_sample_data_flights WHERE ABS(AvgTicketPrice * -2) > 1000
SELECT AvgTicketPrice, Carrier FROM kibana_sample_data_flights WHERE Carrier LIKE 'JetBeat_'
SELECT AvgTicketPrice, Carrier FROM kibana_sample_data_flights WHERE Carrier LIKE '%Air%'
SELECT ALL OriginWeather FROM kibana_sample_data_flights
SELECT DISTINCT OriginWeather FROM kibana_sample_data_flights
SELECT DISTINCT OriginWeather, FlightDelay FROM kibana_sample_data_flights
SELECT DISTINCT SUBSTRING(OriginWeather, 1, 1) AS origin FROM kibana_sample_data_flights
SELECT DISTINCT SUBSTRING(OriginWeather, 1, 1) AS origin, FlightDelay FROM kibana_sample_data_flights
SELECT COUNT(*) AS count FROM kibana_sample_data_flights