You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by jl...@apache.org on 2020/10/26 22:20:11 UTC
[incubator-pinot] 01/01: Reduce number of sql queries from 10k to
500 in pinot-integration-tests module
This is an automated email from the ASF dual-hosted git repository.
jlli pushed a commit to branch refactor-integration-tests
in repository https://gitbox.apache.org/repos/asf/incubator-pinot.git
commit 5675d4d947647c4587666fc18b9fec3b4f5ddcd0
Author: Jack Li(Analytics Engineering) <jl...@jlli-mn1.linkedin.biz>
AuthorDate: Mon Oct 26 15:19:29 2020 -0700
Reduce number of sql queries from 10k to 500 in pinot-integration-tests module
---
.../tests/BaseClusterIntegrationTestSet.java | 22 +-
...e_Performance_2014_100k_subset.test_queries_500 | 2 +-
...rformance_2014_100k_subset.test_queries_500.sql | 559 +++++++++++++++++++++
3 files changed, 567 insertions(+), 16 deletions(-)
diff --git a/pinot-integration-tests/src/test/java/org/apache/pinot/integration/tests/BaseClusterIntegrationTestSet.java b/pinot-integration-tests/src/test/java/org/apache/pinot/integration/tests/BaseClusterIntegrationTestSet.java
index a937384..b0a6ed2 100644
--- a/pinot-integration-tests/src/test/java/org/apache/pinot/integration/tests/BaseClusterIntegrationTestSet.java
+++ b/pinot-integration-tests/src/test/java/org/apache/pinot/integration/tests/BaseClusterIntegrationTestSet.java
@@ -62,7 +62,7 @@ public abstract class BaseClusterIntegrationTestSet extends BaseClusterIntegrati
private static final String DEFAULT_PQL_QUERY_FILE_NAME =
"On_Time_On_Time_Performance_2014_100k_subset.test_queries_500";
private static final String DEFAULT_SQL_QUERY_FILE_NAME =
- "On_Time_On_Time_Performance_2014_100k_subset.test_queries_10K.sql";
+ "On_Time_On_Time_Performance_2014_100k_subset.test_queries_500.sql";
private static final int DEFAULT_NUM_QUERIES_TO_GENERATE = 100;
private static final int DEFAULT_MAX_NUM_QUERIES_TO_SKIP_IN_QUERY_FILE = 200;
@@ -351,21 +351,13 @@ public abstract class BaseClusterIntegrationTestSet extends BaseClusterIntegrati
assertNotNull(resourceUrl);
File queryFile = new File(resourceUrl.getFile());
- int maxNumQueriesToSkipInQueryFile = getMaxNumQueriesToSkipInQueryFile();
- int queryId = 0;
try (BufferedReader reader = new BufferedReader(new FileReader(queryFile))) {
- while (true) {
- int numQueriesSkipped = RANDOM.nextInt(maxNumQueriesToSkipInQueryFile);
- for (int i = 0; i < numQueriesSkipped; i++) {
- reader.readLine();
- queryId++;
- }
- String queryString = reader.readLine();
- queryId++;
- LOGGER.info("Processing query id - {}", queryId);
- // Reach end of file.
- if (queryString == null) {
- return;
+ String queryString;
+ while ((queryString = reader.readLine()) != null) {
+ // Skip commented line and empty line.
+ queryString = queryString.trim();
+ if (queryString.startsWith("#") || queryString.isEmpty()) {
+ continue;
}
JsonNode query = JsonUtils.stringToJsonNode(queryString);
diff --git a/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_500 b/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_500
index 7c8f6e4..1f884e3 100644
--- a/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_500
+++ b/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_500
@@ -507,4 +507,4 @@
# Distinct Queries
{"hsqls":["SELECT DISTINCT WheelsOff FROM mytable LIMIT 10000"],"pql":"SELECT DISTINCT(WheelsOff) FROM mytable LIMIT 24"}
-{"hsqls":["SELECT COUNT(DISTINCT WheelsOn) FROM mytable LIMIT 10000"],"pql":"SELECT DISTINCTCOUNT(WheelsOn) FROM mytable LIMIT 50"}
\ No newline at end of file
+{"hsqls":["SELECT COUNT(DISTINCT WheelsOn) FROM mytable LIMIT 10000"],"pql":"SELECT DISTINCTCOUNT(WheelsOn) FROM mytable LIMIT 50"}
diff --git a/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_500.sql b/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_500.sql
new file mode 100644
index 0000000..f0b9f53
--- /dev/null
+++ b/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_500.sql
@@ -0,0 +1,559 @@
+# Aggregation
+{"sql":"SELECT AVG(ActualElapsedTime), COUNT(DivDistance), MIN(DepDelay) FROM mytable LIMIT 18"}
+{"sql":"SELECT AVG(ArrDelayMinutes) FROM mytable LIMIT 23"}
+{"sql":"SELECT AVG(ArrTime), AVG(DivDistance), MIN(NASDelay) FROM mytable LIMIT 22"}
+{"sql":"SELECT AVG(CRSDepTime), AVG(ArrDel15), MAX(DepartureDelayGroups) FROM mytable LIMIT 20"}
+{"sql":"SELECT AVG(CarrierDelay), MIN(DivReachedDest), MIN(FirstDepTime) FROM mytable"}
+{"sql":"SELECT AVG(DayOfWeek), AVG(DestAirportID), AVG(DepTime) FROM mytable LIMIT 16"}
+{"sql":"SELECT AVG(DepDel15), MAX(LateAircraftDelay) FROM mytable LIMIT 17"}
+{"sql":"SELECT AVG(DestAirportSeqID), SUM(DestCityMarketID) FROM mytable LIMIT 10"}
+{"sql":"SELECT AVG(LateAircraftDelay), SUM(DaysSinceEpoch), MAX(\"Month\") FROM mytable LIMIT 24","hsqls":["SELECT AVG(LateAircraftDelay), SUM(DaysSinceEpoch), MAX(Month) FROM mytable LIMIT 24"]}
+{"sql":"SELECT AVG(LongestAddGTime), COUNT(DepDelayMinutes) FROM mytable LIMIT 2"}
+{"sql":"SELECT AVG(LongestAddGTime), MAX(DivArrDelay) FROM mytable LIMIT 17"}
+{"sql":"SELECT AVG(Quarter), MIN(DayOfWeek), SUM(TaxiIn) FROM mytable"}
+{"sql":"SELECT AVG(TotalAddGTime), COUNT(DivAirportLandings) FROM mytable LIMIT 20"}
+{"sql":"SELECT AVG(WheelsOn), AVG(WheelsOff) FROM mytable LIMIT 27"}
+{"sql":"SELECT AVG(\"Month\"), AVG(LateAircraftDelay), MAX(\"Month\") FROM mytable LIMIT 4","hsqls":["SELECT AVG(Month), AVG(LateAircraftDelay), MAX(Month) FROM mytable LIMIT 4"]}
+{"sql":"SELECT AVG(\"Month\"), MIN(DepartureDelayGroups) FROM mytable LIMIT 16","hsqls":["SELECT AVG(Month), MIN(DepartureDelayGroups) FROM mytable LIMIT 16"]}
+{"sql":"SELECT AVG(\"Year\"), AVG(DivReachedDest), MIN(ArrDel15) FROM mytable LIMIT 22","hsqls":["SELECT AVG(Year), AVG(DivReachedDest), MIN(ArrDel15) FROM mytable LIMIT 22"]}
+{"sql":"SELECT COUNT(*) FROM mytable"}
+{"sql":"SELECT COUNT(ArrDelayMinutes), MAX(ArrDelayMinutes), SUM(TaxiIn) FROM mytable LIMIT 16"}
+{"sql":"SELECT COUNT(ArrDelayMinutes), SUM(SecurityDelay) FROM mytable LIMIT 11"}
+{"sql":"SELECT COUNT(Carrier), AVG(DivDistance), SUM(DistanceGroup) FROM mytable LIMIT 14"}
+{"sql":"SELECT COUNT(CarrierDelay), SUM(DepartureDelayGroups) FROM mytable LIMIT 9"}
+{"sql":"SELECT COUNT(DayofMonth), COUNT(OriginCityName), COUNT(TailNum) FROM mytable LIMIT 5"}
+{"sql":"SELECT COUNT(DepDel15), COUNT(DepDelay), SUM(DepartureDelayGroups) FROM mytable LIMIT 13"}
+{"sql":"SELECT COUNT(DestCityName), MIN(\"Month\") FROM mytable LIMIT 20","hsqls":["SELECT COUNT(DestCityName), MIN(Month) FROM mytable LIMIT 20"]}
+{"sql":"SELECT COUNT(DestStateFips), SUM(CRSElapsedTime) FROM mytable LIMIT 13"}
+{"sql":"SELECT COUNT(Origin), MIN(ArrDel15), MIN(ArrivalDelayGroups) FROM mytable LIMIT 10"}
+{"sql":"SELECT COUNT(OriginAirportID), AVG(FlightNum) FROM mytable LIMIT 23"}
+{"sql":"SELECT COUNT(OriginCityMarketID), MIN(SecurityDelay), MAX(DepTime) FROM mytable LIMIT 6"}
+{"sql":"SELECT MAX(ArrDelay), AVG(Distance), MIN(DayofMonth) FROM mytable LIMIT 23"}
+{"sql":"SELECT MAX(ArrDelayMinutes) FROM mytable LIMIT 21"}
+{"sql":"SELECT MAX(ArrivalDelayGroups) FROM mytable LIMIT 15"}
+{"sql":"SELECT MAX(CRSArrTime), SUM(ArrDelay), MAX(DayOfWeek) FROM mytable LIMIT 4"}
+{"sql":"SELECT MAX(DaysSinceEpoch), SUM(DestStateFips) FROM mytable"}
+{"sql":"SELECT MAX(DepTime), AVG(OriginWac), AVG(OriginCityMarketID) FROM mytable LIMIT 15"}
+{"sql":"SELECT MAX(DestAirportID), AVG(CRSElapsedTime), MAX(DivActualElapsedTime) FROM mytable LIMIT 18"}
+{"sql":"SELECT MAX(DestAirportID), MAX(DestStateFips), MIN(DestAirportID) FROM mytable LIMIT 16"}
+{"sql":"SELECT MAX(DestAirportSeqID), MAX(AirTime) FROM mytable LIMIT 22"}
+{"sql":"SELECT MAX(WheelsOff), MIN(LateAircraftDelay), COUNT(FlightDate) FROM mytable LIMIT 13"}
+{"sql":"SELECT MAX(\"Year\"), MIN(Distance) FROM mytable","hsqls":["SELECT MAX(Year), MIN(Distance) FROM mytable"]}
+{"sql":"SELECT MAX(\"Year\"), SUM(OriginAirportSeqID) FROM mytable LIMIT 25","hsqls":["SELECT MAX(Year), SUM(OriginAirportSeqID) FROM mytable LIMIT 25"]}
+{"sql":"SELECT MIN(AirTime), MAX(CRSArrTime), MIN(DivReachedDest) FROM mytable LIMIT 3"}
+{"sql":"SELECT MIN(DepDelayMinutes), MIN(DaysSinceEpoch), MAX(DivReachedDest) FROM mytable LIMIT 12"}
+{"sql":"SELECT MIN(Diverted), MAX(\"Month\") FROM mytable LIMIT 20","hsqls":["SELECT MIN(Diverted), MAX(Month) FROM mytable LIMIT 20"]}
+{"sql":"SELECT MIN(FlightNum), SUM(DestAirportSeqID) FROM mytable LIMIT 26"}
+{"sql":"SELECT MIN(OriginAirportSeqID), COUNT(OriginStateFips), AVG(NASDelay) FROM mytable LIMIT 16"}
+{"sql":"SELECT MIN(Quarter), MIN(DestCityMarketID), MIN(NASDelay) FROM mytable LIMIT 21"}
+{"sql":"SELECT MIN(SecurityDelay), MIN(DivArrDelay), MIN(DestAirportSeqID) FROM mytable LIMIT 13"}
+{"sql":"SELECT MIN(WheelsOn), MIN(ActualElapsedTime), AVG(OriginAirportID) FROM mytable LIMIT 1"}
+{"sql":"SELECT MIN(\"Year\") FROM mytable LIMIT 18","hsqls":["SELECT MIN(Year) FROM mytable LIMIT 18"]}
+{"sql":"SELECT SUM(CarrierDelay), SUM(DivActualElapsedTime), AVG(DepDelayMinutes) FROM mytable LIMIT 25"}
+{"sql":"SELECT SUM(DepDel15), SUM(WeatherDelay), AVG(Cancelled) FROM mytable LIMIT 16"}
+{"sql":"SELECT SUM(DepDelayMinutes), COUNT(OriginCityName), COUNT(DivAirportLandings) FROM mytable LIMIT 29"}
+{"sql":"SELECT SUM(DestAirportSeqID), MIN(\"Month\"), MAX(DayOfWeek) FROM mytable LIMIT 20","hsqls":["SELECT SUM(DestAirportSeqID), MIN(Month), MAX(DayOfWeek) FROM mytable LIMIT 20"]}
+{"sql":"SELECT SUM(LateAircraftDelay), AVG(AirlineID) FROM mytable LIMIT 5"}
+{"sql":"SELECT SUM(LongestAddGTime), MIN(TaxiIn), AVG(LateAircraftDelay) FROM mytable LIMIT 2"}
+{"sql":"SELECT SUM(NASDelay), MAX(WheelsOff), SUM(ArrDelay) FROM mytable LIMIT 13"}
+{"sql":"SELECT SUM(OriginAirportID), COUNT(TailNum), MIN(DestStateFips) FROM mytable LIMIT 8"}
+{"sql":"SELECT SUM(WheelsOff), SUM(CRSArrTime), SUM(DestStateFips) FROM mytable LIMIT 11"}
+{"sql":"SELECT SUM(\"Year\"), AVG(OriginStateFips) FROM mytable LIMIT 24","hsqls":["SELECT SUM(Year), AVG(OriginStateFips) FROM mytable LIMIT 24"]}
+{"sql":"SELECT SUM(\"Year\"), MIN(OriginCityMarketID) FROM mytable LIMIT 11","hsqls":["SELECT SUM(Year), MIN(OriginCityMarketID) FROM mytable LIMIT 11"]}
+
+# Grouping on Aggregation
+{"sql":"SELECT ActualElapsedTime, COUNT(DayofMonth), AVG(Cancelled), MIN(OriginCityMarketID) FROM mytable GROUP BY ActualElapsedTime ORDER BY ActualElapsedTime LIMIT 22","hsqls":["SELECT ActualElapsedTime, COUNT(DayofMonth), AVG(Cancelled), MIN(OriginCityMarketID) FROM mytable GROUP BY ActualElapsedTime ORDER BY ActualElapsedTime LIMIT 22"]}
+{"sql":"SELECT ActualElapsedTime, DestStateName, DivAirportLandings, SUM(DivReachedDest), COUNT(WheelsOff) FROM mytable GROUP BY ActualElapsedTime, DestStateName, DivAirportLandings ORDER BY ActualElapsedTime, DestStateName, DivAirportLandings LIMIT 24","hsqls":["SELECT ActualElapsedTime, DestStateName, DivAirportLandings, SUM(DivReachedDest), COUNT(WheelsOff) FROM mytable GROUP BY ActualElapsedTime, DestStateName, DivAirportLandings ORDER BY ActualElapsedTime, DestStateName, DivAirpor [...]
+{"sql":"SELECT AirTime, COUNT(DestCityMarketID) FROM mytable GROUP BY AirTime ORDER BY AirTime LIMIT 28","hsqls":["SELECT AirTime, COUNT(DestCityMarketID) FROM mytable GROUP BY AirTime ORDER BY AirTime LIMIT 28"]}
+{"sql":"SELECT AirTime, COUNT(DestStateName), MAX(DepDel15), MIN(TaxiIn) FROM mytable GROUP BY AirTime ORDER BY AirTime LIMIT 3","hsqls":["SELECT AirTime, COUNT(DestStateName), MAX(DepDel15), MIN(TaxiIn) FROM mytable GROUP BY AirTime ORDER BY AirTime LIMIT 3"]}
+{"sql":"SELECT AirTime, WheelsOn, SUM(WheelsOn), AVG(ActualElapsedTime), COUNT(DivReachedDest) FROM mytable GROUP BY AirTime, WheelsOn ORDER BY AirTime, WheelsOn LIMIT 28","hsqls":["SELECT AirTime, WheelsOn, SUM(WheelsOn), AVG(ActualElapsedTime), COUNT(DivReachedDest) FROM mytable GROUP BY AirTime, WheelsOn ORDER BY AirTime, WheelsOn LIMIT 28"]}
+{"sql":"SELECT AirlineID, OriginAirportID, MIN(LateAircraftDelay) FROM mytable GROUP BY AirlineID, OriginAirportID ORDER BY AirlineID, OriginAirportID LIMIT 21","hsqls":["SELECT AirlineID, OriginAirportID, MIN(LateAircraftDelay) FROM mytable GROUP BY AirlineID, OriginAirportID ORDER BY AirlineID, OriginAirportID LIMIT 21"]}
+{"sql":"SELECT AirlineID, WheelsOn, AVG(LateAircraftDelay) FROM mytable GROUP BY AirlineID, WheelsOn ORDER BY AirlineID, WheelsOn LIMIT 11","hsqls":["SELECT AirlineID, WheelsOn, AVG(LateAircraftDelay) FROM mytable GROUP BY AirlineID, WheelsOn ORDER BY AirlineID, WheelsOn LIMIT 11"]}
+{"sql":"SELECT ArrDel15, DestStateName, DayofMonth, COUNT(SecurityDelay), AVG(CarrierDelay), COUNT(FirstDepTime) FROM mytable GROUP BY ArrDel15, DestStateName, DayofMonth ORDER BY ArrDel15, DestStateName, DayofMonth LIMIT 23","hsqls":["SELECT ArrDel15, DestStateName, DayofMonth, COUNT(SecurityDelay), AVG(CarrierDelay), COUNT(FirstDepTime) FROM mytable GROUP BY ArrDel15, DestStateName, DayofMonth ORDER BY ArrDel15, DestStateName, DayofMonth LIMIT 23"]}
+{"sql":"SELECT ArrDel15, MIN(DestAirportSeqID), COUNT(Distance) FROM mytable GROUP BY ArrDel15 ORDER BY ArrDel15 LIMIT 7","hsqls":["SELECT ArrDel15, MIN(DestAirportSeqID), COUNT(Distance) FROM mytable GROUP BY ArrDel15 ORDER BY ArrDel15 LIMIT 7"]}
+{"sql":"SELECT ArrDel15, OriginStateName, MAX(AirTime) FROM mytable GROUP BY ArrDel15, OriginStateName ORDER BY ArrDel15, OriginStateName LIMIT 2","hsqls":["SELECT ArrDel15, OriginStateName, MAX(AirTime) FROM mytable GROUP BY ArrDel15, OriginStateName ORDER BY ArrDel15, OriginStateName LIMIT 2"]}
+{"sql":"SELECT ArrDelay, COUNT(*) FROM mytable GROUP BY ArrDelay ORDER BY ArrDelay LIMIT 10","hsqls":["SELECT ArrDelay, COUNT(*) FROM mytable GROUP BY ArrDelay ORDER BY ArrDelay LIMIT 10"]}
+{"sql":"SELECT ArrDelay, CRSElapsedTime, OriginAirportID, COUNT(DivAirportLandings) FROM mytable GROUP BY ArrDelay, CRSElapsedTime, OriginAirportID ORDER BY ArrDelay, CRSElapsedTime, OriginAirportID LIMIT 19","hsqls":["SELECT ArrDelay, CRSElapsedTime, OriginAirportID, COUNT(DivAirportLandings) FROM mytable GROUP BY ArrDelay, CRSElapsedTime, OriginAirportID ORDER BY ArrDelay, CRSElapsedTime, OriginAirportID LIMIT 19"]}
+{"sql":"SELECT ArrDelayMinutes, AVG(CRSDepTime), MAX(SecurityDelay) FROM mytable GROUP BY ArrDelayMinutes ORDER BY ArrDelayMinutes LIMIT 15","hsqls":["SELECT ArrDelayMinutes, AVG(CRSDepTime), MAX(SecurityDelay) FROM mytable GROUP BY ArrDelayMinutes ORDER BY ArrDelayMinutes LIMIT 15"]}
+{"sql":"SELECT ArrDelayMinutes, ArrDel15, COUNT(*) FROM mytable GROUP BY ArrDelayMinutes, ArrDel15 ORDER BY ArrDelayMinutes, ArrDel15 LIMIT 3","hsqls":["SELECT ArrDelayMinutes, ArrDel15, COUNT(*) FROM mytable GROUP BY ArrDelayMinutes, ArrDel15 ORDER BY ArrDelayMinutes, ArrDel15 LIMIT 3"]}
+{"sql":"SELECT ArrDelayMinutes, ArrivalDelayGroups, MAX(DestAirportSeqID), MIN(TotalAddGTime), COUNT(LateAircraftDelay) FROM mytable GROUP BY ArrDelayMinutes, ArrivalDelayGroups ORDER BY ArrDelayMinutes, ArrivalDelayGroups LIMIT 19","hsqls":["SELECT ArrDelayMinutes, ArrivalDelayGroups, MAX(DestAirportSeqID), MIN(TotalAddGTime), COUNT(LateAircraftDelay) FROM mytable GROUP BY ArrDelayMinutes, ArrivalDelayGroups ORDER BY ArrDelayMinutes, ArrivalDelayGroups LIMIT 19"]}
+{"sql":"SELECT ArrDelayMinutes, Dest, AirlineID, MAX(DepTime), SUM(DistanceGroup) FROM mytable GROUP BY ArrDelayMinutes, Dest, AirlineID ORDER BY ArrDelayMinutes, Dest, AirlineID LIMIT 13","hsqls":["SELECT ArrDelayMinutes, Dest, AirlineID, MAX(DepTime), SUM(DistanceGroup) FROM mytable GROUP BY ArrDelayMinutes, Dest, AirlineID ORDER BY ArrDelayMinutes, Dest, AirlineID LIMIT 13"]}
+{"sql":"SELECT ArrTime, CRSElapsedTime, MIN(DestAirportID), AVG(CRSArrTime) FROM mytable GROUP BY ArrTime, CRSElapsedTime ORDER BY ArrTime, CRSElapsedTime LIMIT 29","hsqls":["SELECT ArrTime, CRSElapsedTime, MIN(DestAirportID), AVG(CRSArrTime) FROM mytable GROUP BY ArrTime, CRSElapsedTime ORDER BY ArrTime, CRSElapsedTime LIMIT 29"]}
+{"sql":"SELECT ArrTime, DayofMonth, WheelsOn, MIN(ArrDelay), MAX(DestWac) FROM mytable GROUP BY ArrTime, DayofMonth, WheelsOn ORDER BY ArrTime, DayofMonth, WheelsOn LIMIT 17","hsqls":["SELECT ArrTime, DayofMonth, WheelsOn, MIN(ArrDelay), MAX(DestWac) FROM mytable GROUP BY ArrTime, DayofMonth, WheelsOn ORDER BY ArrTime, DayofMonth, WheelsOn LIMIT 17"]}
+{"sql":"SELECT ArrTime, NASDelay, WheelsOn, COUNT(ArrDel15), MIN(OriginCityMarketID) FROM mytable GROUP BY ArrTime, NASDelay, WheelsOn ORDER BY ArrTime, NASDelay, WheelsOn LIMIT 27","hsqls":["SELECT ArrTime, NASDelay, WheelsOn, COUNT(ArrDel15), MIN(OriginCityMarketID) FROM mytable GROUP BY ArrTime, NASDelay, WheelsOn ORDER BY ArrTime, NASDelay, WheelsOn LIMIT 27"]}
+{"sql":"SELECT ArrTimeBlk, AirlineID, DaysSinceEpoch, MIN(DestCityMarketID), AVG(DivArrDelay) FROM mytable GROUP BY ArrTimeBlk, AirlineID, DaysSinceEpoch ORDER BY ArrTimeBlk, AirlineID, DaysSinceEpoch LIMIT 6","hsqls":["SELECT ArrTimeBlk, AirlineID, DaysSinceEpoch, MIN(DestCityMarketID), AVG(DivArrDelay) FROM mytable GROUP BY ArrTimeBlk, AirlineID, DaysSinceEpoch ORDER BY ArrTimeBlk, AirlineID, DaysSinceEpoch LIMIT 6"]}
+{"sql":"SELECT ArrTimeBlk, TailNum, COUNT(*) FROM mytable GROUP BY ArrTimeBlk, TailNum ORDER BY ArrTimeBlk, TailNum LIMIT 10","hsqls":["SELECT ArrTimeBlk, TailNum, COUNT(*) FROM mytable GROUP BY ArrTimeBlk, TailNum ORDER BY ArrTimeBlk, TailNum LIMIT 10"]}
+{"sql":"SELECT ArrivalDelayGroups, AVG(DestCityMarketID), COUNT(Diverted), AVG(LateAircraftDelay) FROM mytable GROUP BY ArrivalDelayGroups ORDER BY ArrivalDelayGroups LIMIT 19","hsqls":["SELECT ArrivalDelayGroups, AVG(DestCityMarketID), COUNT(Diverted), AVG(LateAircraftDelay) FROM mytable GROUP BY ArrivalDelayGroups ORDER BY ArrivalDelayGroups LIMIT 19"]}
+{"sql":"SELECT ArrivalDelayGroups, COUNT(Flights), COUNT(DepTime) FROM mytable GROUP BY ArrivalDelayGroups ORDER BY ArrivalDelayGroups LIMIT 12","hsqls":["SELECT ArrivalDelayGroups, COUNT(Flights), COUNT(DepTime) FROM mytable GROUP BY ArrivalDelayGroups ORDER BY ArrivalDelayGroups LIMIT 12"]}
+{"sql":"SELECT ArrivalDelayGroups, MIN(LateAircraftDelay), MIN(NASDelay), SUM(Quarter) FROM mytable GROUP BY ArrivalDelayGroups ORDER BY ArrivalDelayGroups LIMIT 20","hsqls":["SELECT ArrivalDelayGroups, MIN(LateAircraftDelay), MIN(NASDelay), SUM(Quarter) FROM mytable GROUP BY ArrivalDelayGroups ORDER BY ArrivalDelayGroups LIMIT 20"]}
+{"sql":"SELECT CRSArrTime, COUNT(AirTime), AVG(LateAircraftDelay) FROM mytable GROUP BY CRSArrTime ORDER BY CRSArrTime LIMIT 17","hsqls":["SELECT CRSArrTime, COUNT(AirTime), AVG(LateAircraftDelay) FROM mytable GROUP BY CRSArrTime ORDER BY CRSArrTime LIMIT 17"]}
+{"sql":"SELECT CRSArrTime, COUNT(OriginAirportSeqID), MIN(AirTime) FROM mytable GROUP BY CRSArrTime ORDER BY CRSArrTime LIMIT 27","hsqls":["SELECT CRSArrTime, COUNT(OriginAirportSeqID), MIN(AirTime) FROM mytable GROUP BY CRSArrTime ORDER BY CRSArrTime LIMIT 27"]}
+{"sql":"SELECT CRSArrTime, MAX(OriginStateFips) FROM mytable GROUP BY CRSArrTime ORDER BY CRSArrTime LIMIT 4","hsqls":["SELECT CRSArrTime, MAX(OriginStateFips) FROM mytable GROUP BY CRSArrTime ORDER BY CRSArrTime LIMIT 4"]}
+{"sql":"SELECT CRSArrTime, Origin, COUNT(*) FROM mytable GROUP BY CRSArrTime, Origin ORDER BY CRSArrTime, Origin LIMIT 5","hsqls":["SELECT CRSArrTime, Origin, COUNT(*) FROM mytable GROUP BY CRSArrTime, Origin ORDER BY CRSArrTime, Origin LIMIT 5"]}
+{"sql":"SELECT CancellationCode, MAX(DivActualElapsedTime), COUNT(DepTime), MAX(ArrTime) FROM mytable GROUP BY CancellationCode ORDER BY CancellationCode LIMIT 19","hsqls":["SELECT CancellationCode, MAX(DivActualElapsedTime), COUNT(DepTime), MAX(ArrTime) FROM mytable GROUP BY CancellationCode ORDER BY CancellationCode LIMIT 19"]}
+{"sql":"SELECT CancellationCode, MAX(Flights), MAX(DaysSinceEpoch) FROM mytable GROUP BY CancellationCode ORDER BY CancellationCode LIMIT 9","hsqls":["SELECT CancellationCode, MAX(Flights), MAX(DaysSinceEpoch) FROM mytable GROUP BY CancellationCode ORDER BY CancellationCode LIMIT 9"]}
+{"sql":"SELECT CancellationCode, MAX(SecurityDelay), COUNT(CarrierDelay) FROM mytable GROUP BY CancellationCode ORDER BY CancellationCode LIMIT 10","hsqls":["SELECT CancellationCode, MAX(SecurityDelay), COUNT(CarrierDelay) FROM mytable GROUP BY CancellationCode ORDER BY CancellationCode LIMIT 10"]}
+{"sql":"SELECT Cancelled, DepDel15, AVG(DepDelay), AVG(DivArrDelay), AVG(DepartureDelayGroups) FROM mytable GROUP BY Cancelled, DepDel15 ORDER BY Cancelled, DepDel15 LIMIT 26","hsqls":["SELECT Cancelled, DepDel15, AVG(DepDelay), AVG(DivArrDelay), AVG(DepartureDelayGroups) FROM mytable GROUP BY Cancelled, DepDel15 ORDER BY Cancelled, DepDel15 LIMIT 26"]}
+{"sql":"SELECT Cancelled, DivAirportLandings, COUNT(*) FROM mytable GROUP BY Cancelled, DivAirportLandings ORDER BY Cancelled, DivAirportLandings LIMIT 10","hsqls":["SELECT Cancelled, DivAirportLandings, COUNT(*) FROM mytable GROUP BY Cancelled, DivAirportLandings ORDER BY Cancelled, DivAirportLandings LIMIT 10"]}
+{"sql":"SELECT Cancelled, SUM(DepDel15), MIN(DivDistance) FROM mytable GROUP BY Cancelled ORDER BY Cancelled LIMIT 5","hsqls":["SELECT Cancelled, SUM(DepDel15), MIN(DivDistance) FROM mytable GROUP BY Cancelled ORDER BY Cancelled LIMIT 5"]}
+{"sql":"SELECT Carrier, ArrDel15, ArrDelay, MAX(DivArrDelay), COUNT(FlightDate) FROM mytable GROUP BY Carrier, ArrDel15, ArrDelay ORDER BY Carrier, ArrDel15, ArrDelay LIMIT 12","hsqls":["SELECT Carrier, ArrDel15, ArrDelay, MAX(DivArrDelay), COUNT(FlightDate) FROM mytable GROUP BY Carrier, ArrDel15, ArrDelay ORDER BY Carrier, ArrDel15, ArrDelay LIMIT 12"]}
+{"sql":"SELECT Carrier, ArrDel15, ArrivalDelayGroups, COUNT(NASDelay), MAX(DivActualElapsedTime), MAX(CRSDepTime) FROM mytable GROUP BY Carrier, ArrDel15, ArrivalDelayGroups ORDER BY Carrier, ArrDel15, ArrivalDelayGroups LIMIT 4","hsqls":["SELECT Carrier, ArrDel15, ArrivalDelayGroups, COUNT(NASDelay), MAX(DivActualElapsedTime), MAX(CRSDepTime) FROM mytable GROUP BY Carrier, ArrDel15, ArrivalDelayGroups ORDER BY Carrier, ArrDel15, ArrivalDelayGroups LIMIT 4"]}
+{"sql":"SELECT Carrier, MAX(DestStateFips), MIN(NASDelay), AVG(DivAirportLandings) FROM mytable GROUP BY Carrier ORDER BY Carrier LIMIT 5","hsqls":["SELECT Carrier, MAX(DestStateFips), MIN(NASDelay), AVG(DivAirportLandings) FROM mytable GROUP BY Carrier ORDER BY Carrier LIMIT 5"]}
+{"sql":"SELECT Carrier, Origin, ArrDelay, MIN(Cancelled) FROM mytable GROUP BY Carrier, Origin, ArrDelay ORDER BY Carrier, Origin, ArrDelay LIMIT 19","hsqls":["SELECT Carrier, Origin, ArrDelay, MIN(Cancelled) FROM mytable GROUP BY Carrier, Origin, ArrDelay ORDER BY Carrier, Origin, ArrDelay LIMIT 19"]}
+{"sql":"SELECT Carrier, UniqueCarrier, MAX(DivDistance), AVG(CarrierDelay), AVG(SecurityDelay) FROM mytable GROUP BY Carrier, UniqueCarrier ORDER BY Carrier, UniqueCarrier LIMIT 10","hsqls":["SELECT Carrier, UniqueCarrier, MAX(DivDistance), AVG(CarrierDelay), AVG(SecurityDelay) FROM mytable GROUP BY Carrier, UniqueCarrier ORDER BY Carrier, UniqueCarrier LIMIT 10"]}
+{"sql":"SELECT CarrierDelay, AVG(DayofMonth), MIN(DepDel15), SUM(Quarter) FROM mytable GROUP BY CarrierDelay ORDER BY CarrierDelay LIMIT 26","hsqls":["SELECT CarrierDelay, AVG(DayofMonth), MIN(DepDel15), SUM(Quarter) FROM mytable GROUP BY CarrierDelay ORDER BY CarrierDelay LIMIT 26"]}
+{"sql":"SELECT CarrierDelay, NASDelay, WheelsOn, AVG(FlightNum) FROM mytable GROUP BY CarrierDelay, NASDelay, WheelsOn ORDER BY CarrierDelay, NASDelay, WheelsOn LIMIT 4","hsqls":["SELECT CarrierDelay, NASDelay, WheelsOn, AVG(FlightNum) FROM mytable GROUP BY CarrierDelay, NASDelay, WheelsOn ORDER BY CarrierDelay, NASDelay, WheelsOn LIMIT 4"]}
+{"sql":"SELECT CarrierDelay, TaxiIn, OriginWac, MAX(OriginCityMarketID) FROM mytable GROUP BY CarrierDelay, TaxiIn, OriginWac ORDER BY CarrierDelay, TaxiIn, OriginWac LIMIT 13","hsqls":["SELECT CarrierDelay, TaxiIn, OriginWac, MAX(OriginCityMarketID) FROM mytable GROUP BY CarrierDelay, TaxiIn, OriginWac ORDER BY CarrierDelay, TaxiIn, OriginWac LIMIT 13"]}
+{"sql":"SELECT DayOfWeek, AVG(TaxiOut), AVG(DepartureDelayGroups), MAX(DivAirportLandings) FROM mytable GROUP BY DayOfWeek ORDER BY DayOfWeek LIMIT 9","hsqls":["SELECT DayOfWeek, AVG(TaxiOut), AVG(DepartureDelayGroups), MAX(DivAirportLandings) FROM mytable GROUP BY DayOfWeek ORDER BY DayOfWeek LIMIT 9"]}
+{"sql":"SELECT DayofMonth, MAX(DestStateFips), MIN(DivDistance), MAX(LateAircraftDelay) FROM mytable GROUP BY DayofMonth ORDER BY DayofMonth LIMIT 21","hsqls":["SELECT DayofMonth, MAX(DestStateFips), MIN(DivDistance), MAX(LateAircraftDelay) FROM mytable GROUP BY DayofMonth ORDER BY DayofMonth LIMIT 21"]}
+{"sql":"SELECT DaysSinceEpoch, AVG(Distance), MIN(AirlineID) FROM mytable GROUP BY DaysSinceEpoch ORDER BY DaysSinceEpoch LIMIT 14","hsqls":["SELECT DaysSinceEpoch, AVG(Distance), MIN(AirlineID) FROM mytable GROUP BY DaysSinceEpoch ORDER BY DaysSinceEpoch LIMIT 14"]}
+{"sql":"SELECT DaysSinceEpoch, COUNT(DivDistance), AVG(Cancelled), COUNT(LongestAddGTime) FROM mytable GROUP BY DaysSinceEpoch ORDER BY DaysSinceEpoch LIMIT 24","hsqls":["SELECT DaysSinceEpoch, COUNT(DivDistance), AVG(Cancelled), COUNT(LongestAddGTime) FROM mytable GROUP BY DaysSinceEpoch ORDER BY DaysSinceEpoch LIMIT 24"]}
+{"sql":"SELECT DepDelay, DivArrDelay, COUNT(*) FROM mytable GROUP BY DepDelay, DivArrDelay ORDER BY DepDelay, DivArrDelay LIMIT 19","hsqls":["SELECT DepDelay, DivArrDelay, COUNT(*) FROM mytable GROUP BY DepDelay, DivArrDelay ORDER BY DepDelay, DivArrDelay LIMIT 19"]}
+{"sql":"SELECT DepDelay, DivDistance, DaysSinceEpoch, MIN(DepartureDelayGroups), MIN(DepDel15), MAX(DestCityMarketID) FROM mytable GROUP BY DepDelay, DivDistance, DaysSinceEpoch ORDER BY DepDelay, DivDistance, DaysSinceEpoch LIMIT 14","hsqls":["SELECT DepDelay, DivDistance, DaysSinceEpoch, MIN(DepartureDelayGroups), MIN(DepDel15), MAX(DestCityMarketID) FROM mytable GROUP BY DepDelay, DivDistance, DaysSinceEpoch ORDER BY DepDelay, DivDistance, DaysSinceEpoch LIMIT 14"]}
+{"sql":"SELECT DepDelayMinutes, TaxiIn, DestAirportSeqID, MAX(DepDelayMinutes) FROM mytable GROUP BY DepDelayMinutes, TaxiIn, DestAirportSeqID ORDER BY DepDelayMinutes, TaxiIn, DestAirportSeqID LIMIT 11","hsqls":["SELECT DepDelayMinutes, TaxiIn, DestAirportSeqID, MAX(DepDelayMinutes) FROM mytable GROUP BY DepDelayMinutes, TaxiIn, DestAirportSeqID ORDER BY DepDelayMinutes, TaxiIn, DestAirportSeqID LIMIT 11"]}
+{"sql":"SELECT DepTime, AirTime, AirlineID, MIN(WheelsOn), MAX(Diverted), MIN(ArrivalDelayGroups) FROM mytable GROUP BY DepTime, AirTime, AirlineID ORDER BY DepTime, AirTime, AirlineID LIMIT 7","hsqls":["SELECT DepTime, AirTime, AirlineID, MIN(WheelsOn), MAX(Diverted), MIN(ArrivalDelayGroups) FROM mytable GROUP BY DepTime, AirTime, AirlineID ORDER BY DepTime, AirTime, AirlineID LIMIT 7"]}
+{"sql":"SELECT DepTimeBlk, MAX(DepDel15), MIN(Cancelled) FROM mytable GROUP BY DepTimeBlk ORDER BY DepTimeBlk LIMIT 16","hsqls":["SELECT DepTimeBlk, MAX(DepDel15), MIN(Cancelled) FROM mytable GROUP BY DepTimeBlk ORDER BY DepTimeBlk LIMIT 16"]}
+{"sql":"SELECT DepTimeBlk, MAX(DivDistance), AVG(LateAircraftDelay) FROM mytable GROUP BY DepTimeBlk ORDER BY DepTimeBlk LIMIT 13","hsqls":["SELECT DepTimeBlk, MAX(DivDistance), AVG(LateAircraftDelay) FROM mytable GROUP BY DepTimeBlk ORDER BY DepTimeBlk LIMIT 13"]}
+{"sql":"SELECT DepTimeBlk, UniqueCarrier, DayOfWeek, MAX(Distance) FROM mytable GROUP BY DepTimeBlk, UniqueCarrier, DayOfWeek ORDER BY DepTimeBlk, UniqueCarrier, DayOfWeek LIMIT 20","hsqls":["SELECT DepTimeBlk, UniqueCarrier, DayOfWeek, MAX(Distance) FROM mytable GROUP BY DepTimeBlk, UniqueCarrier, DayOfWeek ORDER BY DepTimeBlk, UniqueCarrier, DayOfWeek LIMIT 20"]}
+{"sql":"SELECT DepartureDelayGroups, AVG(AirTime) FROM mytable GROUP BY DepartureDelayGroups ORDER BY DepartureDelayGroups LIMIT 16","hsqls":["SELECT DepartureDelayGroups, AVG(AirTime) FROM mytable GROUP BY DepartureDelayGroups ORDER BY DepartureDelayGroups LIMIT 16"]}
+{"sql":"SELECT DepartureDelayGroups, MIN(CRSElapsedTime) FROM mytable GROUP BY DepartureDelayGroups ORDER BY DepartureDelayGroups LIMIT 9","hsqls":["SELECT DepartureDelayGroups, MIN(CRSElapsedTime) FROM mytable GROUP BY DepartureDelayGroups ORDER BY DepartureDelayGroups LIMIT 9"]}
+{"sql":"SELECT Dest, AirlineID, COUNT(OriginCityMarketID) FROM mytable GROUP BY Dest, AirlineID ORDER BY Dest, AirlineID LIMIT 6","hsqls":["SELECT Dest, AirlineID, COUNT(OriginCityMarketID) FROM mytable GROUP BY Dest, AirlineID ORDER BY Dest, AirlineID LIMIT 6"]}
+{"sql":"SELECT Dest, ArrivalDelayGroups, COUNT(OriginCityMarketID), SUM(ArrDelay), AVG(CRSArrTime) FROM mytable GROUP BY Dest, ArrivalDelayGroups ORDER BY Dest, ArrivalDelayGroups LIMIT 8","hsqls":["SELECT Dest, ArrivalDelayGroups, COUNT(OriginCityMarketID), SUM(ArrDelay), AVG(CRSArrTime) FROM mytable GROUP BY Dest, ArrivalDelayGroups ORDER BY Dest, ArrivalDelayGroups LIMIT 8"]}
+{"sql":"SELECT Dest, OriginStateName, COUNT(OriginState), MAX(Diverted), MAX(DayofMonth) FROM mytable GROUP BY Dest, OriginStateName ORDER BY Dest, OriginStateName LIMIT 29","hsqls":["SELECT Dest, OriginStateName, COUNT(OriginState), MAX(Diverted), MAX(DayofMonth) FROM mytable GROUP BY Dest, OriginStateName ORDER BY Dest, OriginStateName LIMIT 29"]}
+{"sql":"SELECT Dest, SUM(ArrDel15), AVG(TaxiOut), COUNT(AirTime) FROM mytable GROUP BY Dest ORDER BY Dest LIMIT 21","hsqls":["SELECT Dest, SUM(ArrDel15), AVG(TaxiOut), COUNT(AirTime) FROM mytable GROUP BY Dest ORDER BY Dest LIMIT 21"]}
+{"sql":"SELECT DestAirportSeqID, DestCityName, MIN(ArrDelay) FROM mytable GROUP BY DestAirportSeqID, DestCityName ORDER BY DestAirportSeqID, DestCityName LIMIT 13","hsqls":["SELECT DestAirportSeqID, DestCityName, MIN(ArrDelay) FROM mytable GROUP BY DestAirportSeqID, DestCityName ORDER BY DestAirportSeqID, DestCityName LIMIT 13"]}
+{"sql":"SELECT DestAirportSeqID, MAX(DestWac) FROM mytable GROUP BY DestAirportSeqID ORDER BY DestAirportSeqID LIMIT 25","hsqls":["SELECT DestAirportSeqID, MAX(DestWac) FROM mytable GROUP BY DestAirportSeqID ORDER BY DestAirportSeqID LIMIT 25"]}
+{"sql":"SELECT DestAirportSeqID, TailNum, OriginStateName, AVG(DestAirportSeqID), AVG(CarrierDelay) FROM mytable GROUP BY DestAirportSeqID, TailNum, OriginStateName ORDER BY DestAirportSeqID, TailNum, OriginStateName LIMIT 13","hsqls":["SELECT DestAirportSeqID, TailNum, OriginStateName, AVG(DestAirportSeqID), AVG(CarrierDelay) FROM mytable GROUP BY DestAirportSeqID, TailNum, OriginStateName ORDER BY DestAirportSeqID, TailNum, OriginStateName LIMIT 13"]}
+{"sql":"SELECT DestCityMarketID, MAX(OriginCityMarketID), SUM(DepDelayMinutes), COUNT(CRSElapsedTime) FROM mytable GROUP BY DestCityMarketID ORDER BY DestCityMarketID LIMIT 22","hsqls":["SELECT DestCityMarketID, MAX(OriginCityMarketID), SUM(DepDelayMinutes), COUNT(CRSElapsedTime) FROM mytable GROUP BY DestCityMarketID ORDER BY DestCityMarketID LIMIT 22"]}
+{"sql":"SELECT DestCityName, AVG(Quarter), MIN(Distance) FROM mytable GROUP BY DestCityName ORDER BY DestCityName LIMIT 21","hsqls":["SELECT DestCityName, AVG(Quarter), MIN(Distance) FROM mytable GROUP BY DestCityName ORDER BY DestCityName LIMIT 21"]}
+{"sql":"SELECT DestCityName, MAX(DayOfWeek) FROM mytable GROUP BY DestCityName ORDER BY DestCityName LIMIT 7","hsqls":["SELECT DestCityName, MAX(DayOfWeek) FROM mytable GROUP BY DestCityName ORDER BY DestCityName LIMIT 7"]}
+{"sql":"SELECT DestCityName, MAX(TaxiOut) FROM mytable GROUP BY DestCityName ORDER BY DestCityName LIMIT 12","hsqls":["SELECT DestCityName, MAX(TaxiOut) FROM mytable GROUP BY DestCityName ORDER BY DestCityName LIMIT 12"]}
+{"sql":"SELECT DestCityName, OriginAirportID, COUNT(*) FROM mytable GROUP BY DestCityName, OriginAirportID ORDER BY DestCityName, OriginAirportID LIMIT 11","hsqls":["SELECT DestCityName, OriginAirportID, COUNT(*) FROM mytable GROUP BY DestCityName, OriginAirportID ORDER BY DestCityName, OriginAirportID LIMIT 11"]}
+{"sql":"SELECT DestState, AirlineID, COUNT(*) FROM mytable GROUP BY DestState, AirlineID ORDER BY DestState, AirlineID LIMIT 20","hsqls":["SELECT DestState, AirlineID, COUNT(*) FROM mytable GROUP BY DestState, AirlineID ORDER BY DestState, AirlineID LIMIT 20"]}
+{"sql":"SELECT DestState, FlightDate, MIN(WeatherDelay), AVG(DestStateFips), MIN(ArrivalDelayGroups) FROM mytable GROUP BY DestState, FlightDate ORDER BY DestState, FlightDate LIMIT 6","hsqls":["SELECT DestState, FlightDate, MIN(WeatherDelay), AVG(DestStateFips), MIN(ArrivalDelayGroups) FROM mytable GROUP BY DestState, FlightDate ORDER BY DestState, FlightDate LIMIT 6"]}
+{"sql":"SELECT DestState, MAX(WeatherDelay) FROM mytable GROUP BY DestState ORDER BY DestState LIMIT 3","hsqls":["SELECT DestState, MAX(WeatherDelay) FROM mytable GROUP BY DestState ORDER BY DestState LIMIT 3"]}
+{"sql":"SELECT DestStateFips, ArrTime, DaysSinceEpoch, COUNT(*) FROM mytable GROUP BY DestStateFips, ArrTime, DaysSinceEpoch ORDER BY DestStateFips, ArrTime, DaysSinceEpoch LIMIT 7","hsqls":["SELECT DestStateFips, ArrTime, DaysSinceEpoch, COUNT(*) FROM mytable GROUP BY DestStateFips, ArrTime, DaysSinceEpoch ORDER BY DestStateFips, ArrTime, DaysSinceEpoch LIMIT 7"]}
+{"sql":"SELECT DestStateName, DestCityMarketID, DaysSinceEpoch, MIN(NASDelay), MIN(DistanceGroup), MAX(DivAirportLandings) FROM mytable GROUP BY DestStateName, DestCityMarketID, DaysSinceEpoch ORDER BY DestStateName, DestCityMarketID, DaysSinceEpoch LIMIT 7","hsqls":["SELECT DestStateName, DestCityMarketID, DaysSinceEpoch, MIN(NASDelay), MIN(DistanceGroup), MAX(DivAirportLandings) FROM mytable GROUP BY DestStateName, DestCityMarketID, DaysSinceEpoch ORDER BY DestStateName, DestCityMark [...]
+{"sql":"SELECT DestWac, DayofMonth, SUM(DestAirportSeqID), MIN(DivDistance) FROM mytable GROUP BY DestWac, DayofMonth ORDER BY DestWac, DayofMonth LIMIT 8","hsqls":["SELECT DestWac, DayofMonth, SUM(DestAirportSeqID), MIN(DivDistance) FROM mytable GROUP BY DestWac, DayofMonth ORDER BY DestWac, DayofMonth LIMIT 8"]}
+{"sql":"SELECT DestWac, OriginStateFips, MIN(ArrDelayMinutes), SUM(FirstDepTime), MIN(DepDelay) FROM mytable GROUP BY DestWac, OriginStateFips ORDER BY DestWac, OriginStateFips LIMIT 17","hsqls":["SELECT DestWac, OriginStateFips, MIN(ArrDelayMinutes), SUM(FirstDepTime), MIN(DepDelay) FROM mytable GROUP BY DestWac, OriginStateFips ORDER BY DestWac, OriginStateFips LIMIT 17"]}
+{"sql":"SELECT DestWac, OriginWac, CRSDepTime, COUNT(*) FROM mytable GROUP BY DestWac, OriginWac, CRSDepTime ORDER BY DestWac, OriginWac, CRSDepTime LIMIT 19","hsqls":["SELECT DestWac, OriginWac, CRSDepTime, COUNT(*) FROM mytable GROUP BY DestWac, OriginWac, CRSDepTime ORDER BY DestWac, OriginWac, CRSDepTime LIMIT 19"]}
+{"sql":"SELECT Distance, SUM(CarrierDelay), SUM(Flights), AVG(Distance) FROM mytable GROUP BY Distance ORDER BY Distance LIMIT 12","hsqls":["SELECT Distance, SUM(CarrierDelay), SUM(Flights), AVG(Distance) FROM mytable GROUP BY Distance ORDER BY Distance LIMIT 12"]}
+{"sql":"SELECT DistanceGroup, CRSElapsedTime, AVG(DepDelay) FROM mytable GROUP BY DistanceGroup, CRSElapsedTime ORDER BY DistanceGroup, CRSElapsedTime LIMIT 10","hsqls":["SELECT DistanceGroup, CRSElapsedTime, AVG(DepDelay) FROM mytable GROUP BY DistanceGroup, CRSElapsedTime ORDER BY DistanceGroup, CRSElapsedTime LIMIT 10"]}
+{"sql":"SELECT DistanceGroup, OriginCityMarketID, ArrDel15, COUNT(*) FROM mytable GROUP BY DistanceGroup, OriginCityMarketID, ArrDel15 ORDER BY DistanceGroup, OriginCityMarketID, ArrDel15 LIMIT 1","hsqls":["SELECT DistanceGroup, OriginCityMarketID, ArrDel15, COUNT(*) FROM mytable GROUP BY DistanceGroup, OriginCityMarketID, ArrDel15 ORDER BY DistanceGroup, OriginCityMarketID, ArrDel15 LIMIT 1"]}
+{"sql":"SELECT DivActualElapsedTime, SUM(WheelsOff) FROM mytable GROUP BY DivActualElapsedTime ORDER BY DivActualElapsedTime LIMIT 22","hsqls":["SELECT DivActualElapsedTime, SUM(WheelsOff) FROM mytable GROUP BY DivActualElapsedTime ORDER BY DivActualElapsedTime LIMIT 22"]}
+{"sql":"SELECT DivArrDelay, COUNT(ArrTimeBlk) FROM mytable GROUP BY DivArrDelay ORDER BY DivArrDelay LIMIT 23","hsqls":["SELECT DivArrDelay, COUNT(ArrTimeBlk) FROM mytable GROUP BY DivArrDelay ORDER BY DivArrDelay LIMIT 23"]}
+{"sql":"SELECT DivDistance, DestAirportSeqID, Origin, COUNT(DestAirportSeqID), COUNT(Diverted), MIN(CRSArrTime) FROM mytable GROUP BY DivDistance, DestAirportSeqID, Origin ORDER BY DivDistance, DestAirportSeqID, Origin LIMIT 18","hsqls":["SELECT DivDistance, DestAirportSeqID, Origin, COUNT(DestAirportSeqID), COUNT(Diverted), MIN(CRSArrTime) FROM mytable GROUP BY DivDistance, DestAirportSeqID, Origin ORDER BY DivDistance, DestAirportSeqID, Origin LIMIT 18"]}
+{"sql":"SELECT DivReachedDest, ArrivalDelayGroups, MAX(TaxiIn), AVG(OriginStateFips) FROM mytable GROUP BY DivReachedDest, ArrivalDelayGroups ORDER BY DivReachedDest, ArrivalDelayGroups LIMIT 15","hsqls":["SELECT DivReachedDest, ArrivalDelayGroups, MAX(TaxiIn), AVG(OriginStateFips) FROM mytable GROUP BY DivReachedDest, ArrivalDelayGroups ORDER BY DivReachedDest, ArrivalDelayGroups LIMIT 15"]}
+{"sql":"SELECT DivReachedDest, Quarter, DivArrDelay, SUM(FirstDepTime) FROM mytable GROUP BY DivReachedDest, Quarter, DivArrDelay ORDER BY DivReachedDest, Quarter, DivArrDelay LIMIT 10","hsqls":["SELECT DivReachedDest, Quarter, DivArrDelay, SUM(FirstDepTime) FROM mytable GROUP BY DivReachedDest, Quarter, DivArrDelay ORDER BY DivReachedDest, Quarter, DivArrDelay LIMIT 10"]}
+{"sql":"SELECT Diverted, DayOfWeek, AVG(DestCityMarketID), SUM(DepartureDelayGroups), AVG(DestWac) FROM mytable GROUP BY Diverted, DayOfWeek ORDER BY Diverted, DayOfWeek LIMIT 17","hsqls":["SELECT Diverted, DayOfWeek, AVG(DestCityMarketID), SUM(DepartureDelayGroups), AVG(DestWac) FROM mytable GROUP BY Diverted, DayOfWeek ORDER BY Diverted, DayOfWeek LIMIT 17"]}
+{"sql":"SELECT Diverted, OriginState, AirlineID, COUNT(FlightNum) FROM mytable GROUP BY Diverted, OriginState, AirlineID ORDER BY Diverted, OriginState, AirlineID LIMIT 1","hsqls":["SELECT Diverted, OriginState, AirlineID, COUNT(FlightNum) FROM mytable GROUP BY Diverted, OriginState, AirlineID ORDER BY Diverted, OriginState, AirlineID LIMIT 1"]}
+{"sql":"SELECT FirstDepTime, DepTime, DepDel15, MAX(WheelsOn), COUNT(DepDelayMinutes) FROM mytable GROUP BY FirstDepTime, DepTime, DepDel15 ORDER BY FirstDepTime, DepTime, DepDel15 LIMIT 2","hsqls":["SELECT FirstDepTime, DepTime, DepDel15, MAX(WheelsOn), COUNT(DepDelayMinutes) FROM mytable GROUP BY FirstDepTime, DepTime, DepDel15 ORDER BY FirstDepTime, DepTime, DepDel15 LIMIT 2"]}
+{"sql":"SELECT FirstDepTime, SecurityDelay, DestStateFips, COUNT(OriginCityMarketID), MIN(DepDelay) FROM mytable GROUP BY FirstDepTime, SecurityDelay, DestStateFips ORDER BY FirstDepTime, SecurityDelay, DestStateFips LIMIT 13","hsqls":["SELECT FirstDepTime, SecurityDelay, DestStateFips, COUNT(OriginCityMarketID), MIN(DepDelay) FROM mytable GROUP BY FirstDepTime, SecurityDelay, DestStateFips ORDER BY FirstDepTime, SecurityDelay, DestStateFips LIMIT 13"]}
+{"sql":"SELECT FlightDate, OriginWac, DivActualElapsedTime, SUM(Quarter) FROM mytable GROUP BY FlightDate, OriginWac, DivActualElapsedTime ORDER BY FlightDate, OriginWac, DivActualElapsedTime LIMIT 26","hsqls":["SELECT FlightDate, OriginWac, DivActualElapsedTime, SUM(Quarter) FROM mytable GROUP BY FlightDate, OriginWac, DivActualElapsedTime ORDER BY FlightDate, OriginWac, DivActualElapsedTime LIMIT 26"]}
+{"sql":"SELECT FlightDate, TaxiIn, DestAirportSeqID, COUNT(*) FROM mytable GROUP BY FlightDate, TaxiIn, DestAirportSeqID ORDER BY FlightDate, TaxiIn, DestAirportSeqID LIMIT 11","hsqls":["SELECT FlightDate, TaxiIn, DestAirportSeqID, COUNT(*) FROM mytable GROUP BY FlightDate, TaxiIn, DestAirportSeqID ORDER BY FlightDate, TaxiIn, DestAirportSeqID LIMIT 11"]}
+{"sql":"SELECT FlightNum, AVG(DistanceGroup) FROM mytable GROUP BY FlightNum ORDER BY FlightNum LIMIT 14","hsqls":["SELECT FlightNum, AVG(DistanceGroup) FROM mytable GROUP BY FlightNum ORDER BY FlightNum LIMIT 14"]}
+{"sql":"SELECT FlightNum, AVG(OriginAirportSeqID), MAX(DivReachedDest), COUNT(LateAircraftDelay) FROM mytable GROUP BY FlightNum ORDER BY FlightNum LIMIT 28","hsqls":["SELECT FlightNum, AVG(OriginAirportSeqID), MAX(DivReachedDest), COUNT(LateAircraftDelay) FROM mytable GROUP BY FlightNum ORDER BY FlightNum LIMIT 28"]}
+{"sql":"SELECT FlightNum, DestStateName, AVG(OriginWac), MAX(Distance) FROM mytable GROUP BY FlightNum, DestStateName ORDER BY FlightNum, DestStateName LIMIT 7","hsqls":["SELECT FlightNum, DestStateName, AVG(OriginWac), MAX(Distance) FROM mytable GROUP BY FlightNum, DestStateName ORDER BY FlightNum, DestStateName LIMIT 7"]}
+{"sql":"SELECT Flights, DestCityName, CRSElapsedTime, COUNT(DivDistance) FROM mytable GROUP BY Flights, DestCityName, CRSElapsedTime ORDER BY Flights, DestCityName, CRSElapsedTime LIMIT 18","hsqls":["SELECT Flights, DestCityName, CRSElapsedTime, COUNT(DivDistance) FROM mytable GROUP BY Flights, DestCityName, CRSElapsedTime ORDER BY Flights, DestCityName, CRSElapsedTime LIMIT 18"]}
+{"sql":"SELECT LateAircraftDelay, FlightNum, MAX(Flights), SUM(LateAircraftDelay), AVG(CRSArrTime) FROM mytable GROUP BY LateAircraftDelay, FlightNum ORDER BY LateAircraftDelay, FlightNum LIMIT 7","hsqls":["SELECT LateAircraftDelay, FlightNum, MAX(Flights), SUM(LateAircraftDelay), AVG(CRSArrTime) FROM mytable GROUP BY LateAircraftDelay, FlightNum ORDER BY LateAircraftDelay, FlightNum LIMIT 7"]}
+{"sql":"SELECT LateAircraftDelay, MAX(ArrDel15), COUNT(ActualElapsedTime), MIN(LongestAddGTime) FROM mytable GROUP BY LateAircraftDelay ORDER BY LateAircraftDelay LIMIT 17","hsqls":["SELECT LateAircraftDelay, MAX(ArrDel15), COUNT(ActualElapsedTime), MIN(LongestAddGTime) FROM mytable GROUP BY LateAircraftDelay ORDER BY LateAircraftDelay LIMIT 17"]}
+{"sql":"SELECT LongestAddGTime, MIN(ActualElapsedTime), AVG(OriginStateFips) FROM mytable GROUP BY LongestAddGTime ORDER BY LongestAddGTime LIMIT 16","hsqls":["SELECT LongestAddGTime, MIN(ActualElapsedTime), AVG(OriginStateFips) FROM mytable GROUP BY LongestAddGTime ORDER BY LongestAddGTime LIMIT 16"]}
+{"sql":"SELECT NASDelay, DayOfWeek, MIN(ActualElapsedTime) FROM mytable GROUP BY NASDelay, DayOfWeek ORDER BY NASDelay, DayOfWeek LIMIT 1","hsqls":["SELECT NASDelay, DayOfWeek, MIN(ActualElapsedTime) FROM mytable GROUP BY NASDelay, DayOfWeek ORDER BY NASDelay, DayOfWeek LIMIT 1"]}
+{"sql":"SELECT Origin, MAX(DivDistance) FROM mytable GROUP BY Origin ORDER BY Origin LIMIT 28","hsqls":["SELECT Origin, MAX(DivDistance) FROM mytable GROUP BY Origin ORDER BY Origin LIMIT 28"]}
+{"sql":"SELECT OriginAirportID, COUNT(ArrTimeBlk) FROM mytable GROUP BY OriginAirportID ORDER BY OriginAirportID LIMIT 6","hsqls":["SELECT OriginAirportID, COUNT(ArrTimeBlk) FROM mytable GROUP BY OriginAirportID ORDER BY OriginAirportID LIMIT 6"]}
+{"sql":"SELECT OriginAirportSeqID, DayofMonth, COUNT(DivActualElapsedTime), AVG(Diverted), AVG(Flights) FROM mytable GROUP BY OriginAirportSeqID, DayofMonth ORDER BY OriginAirportSeqID, DayofMonth LIMIT 18","hsqls":["SELECT OriginAirportSeqID, DayofMonth, COUNT(DivActualElapsedTime), AVG(Diverted), AVG(Flights) FROM mytable GROUP BY OriginAirportSeqID, DayofMonth ORDER BY OriginAirportSeqID, DayofMonth LIMIT 18"]}
+{"sql":"SELECT OriginCityMarketID, AVG(FirstDepTime) FROM mytable GROUP BY OriginCityMarketID ORDER BY OriginCityMarketID LIMIT 23","hsqls":["SELECT OriginCityMarketID, AVG(FirstDepTime) FROM mytable GROUP BY OriginCityMarketID ORDER BY OriginCityMarketID LIMIT 23"]}
+{"sql":"SELECT OriginCityMarketID, Dest, DestAirportID, COUNT(*) FROM mytable GROUP BY OriginCityMarketID, Dest, DestAirportID ORDER BY OriginCityMarketID, Dest, DestAirportID LIMIT 24","hsqls":["SELECT OriginCityMarketID, Dest, DestAirportID, COUNT(*) FROM mytable GROUP BY OriginCityMarketID, Dest, DestAirportID ORDER BY OriginCityMarketID, Dest, DestAirportID LIMIT 24"]}
+{"sql":"SELECT OriginCityName, TailNum, MAX(DayOfWeek) FROM mytable GROUP BY OriginCityName, TailNum ORDER BY OriginCityName, TailNum LIMIT 13","hsqls":["SELECT OriginCityName, TailNum, MAX(DayOfWeek) FROM mytable GROUP BY OriginCityName, TailNum ORDER BY OriginCityName, TailNum LIMIT 13"]}
+{"sql":"SELECT OriginState, CRSDepTime, SUM(Flights) FROM mytable GROUP BY OriginState, CRSDepTime ORDER BY OriginState, CRSDepTime LIMIT 22","hsqls":["SELECT OriginState, CRSDepTime, SUM(Flights) FROM mytable GROUP BY OriginState, CRSDepTime ORDER BY OriginState, CRSDepTime LIMIT 22"]}
+{"sql":"SELECT OriginState, Carrier, COUNT(*) FROM mytable GROUP BY OriginState, Carrier ORDER BY OriginState, Carrier LIMIT 20","hsqls":["SELECT OriginState, Carrier, COUNT(*) FROM mytable GROUP BY OriginState, Carrier ORDER BY OriginState, Carrier LIMIT 20"]}
+{"sql":"SELECT OriginState, DestState, AirTime, AVG(CRSElapsedTime), MAX(DayOfWeek), AVG(AirlineID) FROM mytable GROUP BY OriginState, DestState, AirTime ORDER BY OriginState, DestState, AirTime LIMIT 12","hsqls":["SELECT OriginState, DestState, AirTime, AVG(CRSElapsedTime), MAX(DayOfWeek), AVG(AirlineID) FROM mytable GROUP BY OriginState, DestState, AirTime ORDER BY OriginState, DestState, AirTime LIMIT 12"]}
+{"sql":"SELECT OriginState, DestState, DestAirportID, COUNT(*) FROM mytable GROUP BY OriginState, DestState, DestAirportID ORDER BY OriginState, DestState, DestAirportID LIMIT 19","hsqls":["SELECT OriginState, DestState, DestAirportID, COUNT(*) FROM mytable GROUP BY OriginState, DestState, DestAirportID ORDER BY OriginState, DestState, DestAirportID LIMIT 19"]}
+{"sql":"SELECT OriginState, DestWac, SUM(TotalAddGTime), COUNT(NASDelay), SUM(WheelsOff) FROM mytable GROUP BY OriginState, DestWac ORDER BY OriginState, DestWac LIMIT 12","hsqls":["SELECT OriginState, DestWac, SUM(TotalAddGTime), COUNT(NASDelay), SUM(WheelsOff) FROM mytable GROUP BY OriginState, DestWac ORDER BY OriginState, DestWac LIMIT 12"]}
+{"sql":"SELECT OriginState, MAX(CarrierDelay), COUNT(ArrDel15), SUM(DepartureDelayGroups) FROM mytable GROUP BY OriginState ORDER BY OriginState LIMIT 6","hsqls":["SELECT OriginState, MAX(CarrierDelay), COUNT(ArrDel15), SUM(DepartureDelayGroups) FROM mytable GROUP BY OriginState ORDER BY OriginState LIMIT 6"]}
+{"sql":"SELECT OriginState, MAX(DivDistance), MAX(DepDelayMinutes), COUNT(DepTimeBlk) FROM mytable GROUP BY OriginState ORDER BY OriginState LIMIT 13","hsqls":["SELECT OriginState, MAX(DivDistance), MAX(DepDelayMinutes), COUNT(DepTimeBlk) FROM mytable GROUP BY OriginState ORDER BY OriginState LIMIT 13"]}
+{"sql":"SELECT OriginState, MIN(DestAirportID), MIN(DepartureDelayGroups) FROM mytable GROUP BY OriginState ORDER BY OriginState LIMIT 14","hsqls":["SELECT OriginState, MIN(DestAirportID), MIN(DepartureDelayGroups) FROM mytable GROUP BY OriginState ORDER BY OriginState LIMIT 14"]}
+{"sql":"SELECT OriginState, MIN(DestCityMarketID), MAX(DestCityMarketID), COUNT(ArrDel15) FROM mytable GROUP BY OriginState ORDER BY OriginState LIMIT 6","hsqls":["SELECT OriginState, MIN(DestCityMarketID), MAX(DestCityMarketID), COUNT(ArrDel15) FROM mytable GROUP BY OriginState ORDER BY OriginState LIMIT 6"]}
+{"sql":"SELECT OriginState, OriginStateFips, MAX(ArrDelay) FROM mytable GROUP BY OriginState, OriginStateFips ORDER BY OriginState, OriginStateFips LIMIT 24","hsqls":["SELECT OriginState, OriginStateFips, MAX(ArrDelay) FROM mytable GROUP BY OriginState, OriginStateFips ORDER BY OriginState, OriginStateFips LIMIT 24"]}
+{"sql":"SELECT OriginState, OriginWac, COUNT(*) FROM mytable GROUP BY OriginState, OriginWac ORDER BY OriginState, OriginWac LIMIT 27","hsqls":["SELECT OriginState, OriginWac, COUNT(*) FROM mytable GROUP BY OriginState, OriginWac ORDER BY OriginState, OriginWac LIMIT 27"]}
+{"sql":"SELECT OriginStateFips, ActualElapsedTime, DepTimeBlk, SUM(DepDel15), AVG(ArrivalDelayGroups), MIN(DepDelay) FROM mytable GROUP BY OriginStateFips, ActualElapsedTime, DepTimeBlk ORDER BY OriginStateFips, ActualElapsedTime, DepTimeBlk LIMIT 10","hsqls":["SELECT OriginStateFips, ActualElapsedTime, DepTimeBlk, SUM(DepDel15), AVG(ArrivalDelayGroups), MIN(DepDelay) FROM mytable GROUP BY OriginStateFips, ActualElapsedTime, DepTimeBlk ORDER BY OriginStateFips, ActualElapsedTime, DepTi [...]
+{"sql":"SELECT OriginStateFips, AirlineID, ArrivalDelayGroups, AVG(Quarter) FROM mytable GROUP BY OriginStateFips, AirlineID, ArrivalDelayGroups ORDER BY OriginStateFips, AirlineID, ArrivalDelayGroups LIMIT 2","hsqls":["SELECT OriginStateFips, AirlineID, ArrivalDelayGroups, AVG(Quarter) FROM mytable GROUP BY OriginStateFips, AirlineID, ArrivalDelayGroups ORDER BY OriginStateFips, AirlineID, ArrivalDelayGroups LIMIT 2"]}
+{"sql":"SELECT OriginStateFips, DayofMonth, COUNT(*) FROM mytable GROUP BY OriginStateFips, DayofMonth ORDER BY OriginStateFips, DayofMonth LIMIT 28","hsqls":["SELECT OriginStateFips, DayofMonth, COUNT(*) FROM mytable GROUP BY OriginStateFips, DayofMonth ORDER BY OriginStateFips, DayofMonth LIMIT 28"]}
+{"sql":"SELECT OriginStateFips, DaysSinceEpoch, COUNT(OriginStateFips), AVG(CarrierDelay) FROM mytable GROUP BY OriginStateFips, DaysSinceEpoch ORDER BY OriginStateFips, DaysSinceEpoch LIMIT 1","hsqls":["SELECT OriginStateFips, DaysSinceEpoch, COUNT(OriginStateFips), AVG(CarrierDelay) FROM mytable GROUP BY OriginStateFips, DaysSinceEpoch ORDER BY OriginStateFips, DaysSinceEpoch LIMIT 1"]}
+{"sql":"SELECT OriginWac, DayOfWeek, MAX(DestAirportID), MAX(CarrierDelay) FROM mytable GROUP BY OriginWac, DayOfWeek ORDER BY OriginWac, DayOfWeek LIMIT 16","hsqls":["SELECT OriginWac, DayOfWeek, MAX(DestAirportID), MAX(CarrierDelay) FROM mytable GROUP BY OriginWac, DayOfWeek ORDER BY OriginWac, DayOfWeek LIMIT 16"]}
+{"sql":"SELECT OriginWac, OriginAirportID, AVG(ArrTime), MAX(DestAirportID) FROM mytable GROUP BY OriginWac, OriginAirportID ORDER BY OriginWac, OriginAirportID LIMIT 13","hsqls":["SELECT OriginWac, OriginAirportID, AVG(ArrTime), MAX(DestAirportID) FROM mytable GROUP BY OriginWac, OriginAirportID ORDER BY OriginWac, OriginAirportID LIMIT 13"]}
+{"sql":"SELECT OriginWac, SUM(DivAirportLandings), MAX(TaxiIn), MAX(OriginAirportID) FROM mytable GROUP BY OriginWac ORDER BY OriginWac LIMIT 21","hsqls":["SELECT OriginWac, SUM(DivAirportLandings), MAX(TaxiIn), MAX(OriginAirportID) FROM mytable GROUP BY OriginWac ORDER BY OriginWac LIMIT 21"]}
+{"sql":"SELECT Quarter, CRSDepTime, SUM(DivAirportLandings), COUNT(TaxiOut), AVG(Cancelled) FROM mytable GROUP BY Quarter, CRSDepTime ORDER BY Quarter, CRSDepTime LIMIT 20","hsqls":["SELECT Quarter, CRSDepTime, SUM(DivAirportLandings), COUNT(TaxiOut), AVG(Cancelled) FROM mytable GROUP BY Quarter, CRSDepTime ORDER BY Quarter, CRSDepTime LIMIT 20"]}
+{"sql":"SELECT Quarter, DayOfWeek, SUM(TaxiIn), MAX(ActualElapsedTime), SUM(DivDistance) FROM mytable GROUP BY Quarter, DayOfWeek ORDER BY Quarter, DayOfWeek LIMIT 6","hsqls":["SELECT Quarter, DayOfWeek, SUM(TaxiIn), MAX(ActualElapsedTime), SUM(DivDistance) FROM mytable GROUP BY Quarter, DayOfWeek ORDER BY Quarter, DayOfWeek LIMIT 6"]}
+{"sql":"SELECT Quarter, DestAirportID, COUNT(DistanceGroup), MIN(ArrivalDelayGroups) FROM mytable GROUP BY Quarter, DestAirportID ORDER BY Quarter, DestAirportID LIMIT 4","hsqls":["SELECT Quarter, DestAirportID, COUNT(DistanceGroup), MIN(ArrivalDelayGroups) FROM mytable GROUP BY Quarter, DestAirportID ORDER BY Quarter, DestAirportID LIMIT 4"]}
+{"sql":"SELECT Quarter, SecurityDelay, DepTimeBlk, COUNT(Carrier), MIN(OriginAirportID), COUNT(ArrTime) FROM mytable GROUP BY Quarter, SecurityDelay, DepTimeBlk ORDER BY Quarter, SecurityDelay, DepTimeBlk LIMIT 13","hsqls":["SELECT Quarter, SecurityDelay, DepTimeBlk, COUNT(Carrier), MIN(OriginAirportID), COUNT(ArrTime) FROM mytable GROUP BY Quarter, SecurityDelay, DepTimeBlk ORDER BY Quarter, SecurityDelay, DepTimeBlk LIMIT 13"]}
+{"sql":"SELECT Quarter, TotalAddGTime, CRSElapsedTime, COUNT(*) FROM mytable GROUP BY Quarter, TotalAddGTime, CRSElapsedTime ORDER BY Quarter, TotalAddGTime, CRSElapsedTime LIMIT 9","hsqls":["SELECT Quarter, TotalAddGTime, CRSElapsedTime, COUNT(*) FROM mytable GROUP BY Quarter, TotalAddGTime, CRSElapsedTime ORDER BY Quarter, TotalAddGTime, CRSElapsedTime LIMIT 9"]}
+{"sql":"SELECT Quarter, WheelsOn, MAX(CarrierDelay), AVG(ArrivalDelayGroups), MIN(LongestAddGTime) FROM mytable GROUP BY Quarter, WheelsOn ORDER BY Quarter, WheelsOn LIMIT 19","hsqls":["SELECT Quarter, WheelsOn, MAX(CarrierDelay), AVG(ArrivalDelayGroups), MIN(LongestAddGTime) FROM mytable GROUP BY Quarter, WheelsOn ORDER BY Quarter, WheelsOn LIMIT 19"]}
+{"sql":"SELECT SecurityDelay, AirTime, COUNT(DepDelayMinutes), AVG(DepTime), MIN(OriginCityMarketID) FROM mytable GROUP BY SecurityDelay, AirTime ORDER BY SecurityDelay, AirTime LIMIT 8","hsqls":["SELECT SecurityDelay, AirTime, COUNT(DepDelayMinutes), AVG(DepTime), MIN(OriginCityMarketID) FROM mytable GROUP BY SecurityDelay, AirTime ORDER BY SecurityDelay, AirTime LIMIT 8"]}
+{"sql":"SELECT SecurityDelay, ArrDel15, AVG(DivArrDelay), MAX(FlightNum) FROM mytable GROUP BY SecurityDelay, ArrDel15 ORDER BY SecurityDelay, ArrDel15 LIMIT 11","hsqls":["SELECT SecurityDelay, ArrDel15, AVG(DivArrDelay), MAX(FlightNum) FROM mytable GROUP BY SecurityDelay, ArrDel15 ORDER BY SecurityDelay, ArrDel15 LIMIT 11"]}
+{"sql":"SELECT SecurityDelay, MIN(FlightNum), SUM(DaysSinceEpoch) FROM mytable GROUP BY SecurityDelay ORDER BY SecurityDelay LIMIT 17","hsqls":["SELECT SecurityDelay, MIN(FlightNum), SUM(DaysSinceEpoch) FROM mytable GROUP BY SecurityDelay ORDER BY SecurityDelay LIMIT 17"]}
+{"sql":"SELECT SecurityDelay, Origin, DayofMonth, COUNT(Cancelled) FROM mytable GROUP BY SecurityDelay, Origin, DayofMonth ORDER BY SecurityDelay, Origin, DayofMonth LIMIT 18","hsqls":["SELECT SecurityDelay, Origin, DayofMonth, COUNT(Cancelled) FROM mytable GROUP BY SecurityDelay, Origin, DayofMonth ORDER BY SecurityDelay, Origin, DayofMonth LIMIT 18"]}
+{"sql":"SELECT TailNum, COUNT(*) FROM mytable GROUP BY TailNum ORDER BY TailNum LIMIT 6","hsqls":["SELECT TailNum, COUNT(*) FROM mytable GROUP BY TailNum ORDER BY TailNum LIMIT 6"]}
+{"sql":"SELECT TaxiIn, COUNT(*) FROM mytable GROUP BY TaxiIn ORDER BY TaxiIn LIMIT 23","hsqls":["SELECT TaxiIn, COUNT(*) FROM mytable GROUP BY TaxiIn ORDER BY TaxiIn LIMIT 23"]}
+{"sql":"SELECT TaxiIn, COUNT(DestStateName), SUM(OriginAirportSeqID), MAX(AirTime) FROM mytable GROUP BY TaxiIn ORDER BY TaxiIn LIMIT 10","hsqls":["SELECT TaxiIn, COUNT(DestStateName), SUM(OriginAirportSeqID), MAX(AirTime) FROM mytable GROUP BY TaxiIn ORDER BY TaxiIn LIMIT 10"]}
+{"sql":"SELECT TaxiOut, MAX(DestStateFips), AVG(DestCityMarketID) FROM mytable GROUP BY TaxiOut ORDER BY TaxiOut LIMIT 4","hsqls":["SELECT TaxiOut, MAX(DestStateFips), AVG(DestCityMarketID) FROM mytable GROUP BY TaxiOut ORDER BY TaxiOut LIMIT 4"]}
+{"sql":"SELECT TaxiOut, UniqueCarrier, SUM(WheelsOn), AVG(DestWac) FROM mytable GROUP BY TaxiOut, UniqueCarrier ORDER BY TaxiOut, UniqueCarrier LIMIT 20","hsqls":["SELECT TaxiOut, UniqueCarrier, SUM(WheelsOn), AVG(DestWac) FROM mytable GROUP BY TaxiOut, UniqueCarrier ORDER BY TaxiOut, UniqueCarrier LIMIT 20"]}
+{"sql":"SELECT UniqueCarrier, OriginAirportID, AVG(LongestAddGTime) FROM mytable GROUP BY UniqueCarrier, OriginAirportID ORDER BY UniqueCarrier, OriginAirportID LIMIT 1","hsqls":["SELECT UniqueCarrier, OriginAirportID, AVG(LongestAddGTime) FROM mytable GROUP BY UniqueCarrier, OriginAirportID ORDER BY UniqueCarrier, OriginAirportID LIMIT 1"]}
+{"sql":"SELECT WeatherDelay, DepDel15, DepTimeBlk, COUNT(*) FROM mytable GROUP BY WeatherDelay, DepDel15, DepTimeBlk ORDER BY WeatherDelay, DepDel15, DepTimeBlk LIMIT 16","hsqls":["SELECT WeatherDelay, DepDel15, DepTimeBlk, COUNT(*) FROM mytable GROUP BY WeatherDelay, DepDel15, DepTimeBlk ORDER BY WeatherDelay, DepDel15, DepTimeBlk LIMIT 16"]}
+{"sql":"SELECT WeatherDelay, NASDelay, DayofMonth, MAX(DestAirportSeqID) FROM mytable GROUP BY WeatherDelay, NASDelay, DayofMonth ORDER BY WeatherDelay, NASDelay, DayofMonth LIMIT 6","hsqls":["SELECT WeatherDelay, NASDelay, DayofMonth, MAX(DestAirportSeqID) FROM mytable GROUP BY WeatherDelay, NASDelay, DayofMonth ORDER BY WeatherDelay, NASDelay, DayofMonth LIMIT 6"]}
+{"sql":"SELECT WeatherDelay, Origin, OriginWac, MAX(WheelsOff), MAX(ArrDelayMinutes) FROM mytable GROUP BY WeatherDelay, Origin, OriginWac ORDER BY WeatherDelay, Origin, OriginWac LIMIT 7","hsqls":["SELECT WeatherDelay, Origin, OriginWac, MAX(WheelsOff), MAX(ArrDelayMinutes) FROM mytable GROUP BY WeatherDelay, Origin, OriginWac ORDER BY WeatherDelay, Origin, OriginWac LIMIT 7"]}
+{"sql":"SELECT WheelsOff, TaxiOut, COUNT(*) FROM mytable GROUP BY WheelsOff, TaxiOut ORDER BY WheelsOff, TaxiOut LIMIT 18","hsqls":["SELECT WheelsOff, TaxiOut, COUNT(*) FROM mytable GROUP BY WheelsOff, TaxiOut ORDER BY WheelsOff, TaxiOut LIMIT 18"]}
+{"sql":"SELECT WheelsOn, MIN(Cancelled), COUNT(AirTime), MAX(ActualElapsedTime) FROM mytable GROUP BY WheelsOn ORDER BY WheelsOn LIMIT 12","hsqls":["SELECT WheelsOn, MIN(Cancelled), COUNT(AirTime), MAX(ActualElapsedTime) FROM mytable GROUP BY WheelsOn ORDER BY WheelsOn LIMIT 12"]}
+{"sql":"SELECT WheelsOn, MIN(OriginAirportSeqID), SUM(DepDelay), SUM(DepartureDelayGroups) FROM mytable GROUP BY WheelsOn ORDER BY WheelsOn LIMIT 6","hsqls":["SELECT WheelsOn, MIN(OriginAirportSeqID), SUM(DepDelay), SUM(DepartureDelayGroups) FROM mytable GROUP BY WheelsOn ORDER BY WheelsOn LIMIT 6"]}
+{"sql":"SELECT WheelsOn, OriginStateName, AVG(DepDel15) FROM mytable GROUP BY WheelsOn, OriginStateName ORDER BY WheelsOn, OriginStateName LIMIT 18","hsqls":["SELECT WheelsOn, OriginStateName, AVG(DepDel15) FROM mytable GROUP BY WheelsOn, OriginStateName ORDER BY WheelsOn, OriginStateName LIMIT 18"]}
+
+# Filtering on Aggregation
+{"sql":"SELECT AVG(AirTime), SUM(OriginStateFips) FROM mytable WHERE DivTailNums BETWEEN 'N8315C' AND 'N130DL' OR DivAirports IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') AND TaxiOut NOT IN (59, 112, 57, 72) LIMIT 5","hsqls":["SELECT AVG(AirTime), SUM(OriginStateFips) FROM mytable WHERE (DivTailNums__MV0 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV1 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV2 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV3 BETWEEN 'N8315C' AND 'N130DL' OR DivTailN [...]
+{"sql":"SELECT AVG(ArrDel15) FROM mytable WHERE DivWheelsOffs >= 1610 LIMIT 13","hsqls":["SELECT AVG(CAST(ArrDel15 AS DOUBLE)) FROM mytable WHERE (DivWheelsOffs__MV0 >= 1610 OR DivWheelsOffs__MV1 >= 1610 OR DivWheelsOffs__MV2 >= 1610 OR DivWheelsOffs__MV3 >= 1610 OR DivWheelsOffs__MV4 >= 1610) LIMIT 10000"]}
+{"sql":"SELECT AVG(ArrivalDelayGroups), MIN(Distance) FROM mytable WHERE DestCityMarketID BETWEEN 31337 AND 35389 OR DivDistance BETWEEN 575 AND 971 AND DivWheelsOns IN (1228, 1007) LIMIT 6","hsqls":["SELECT AVG(ArrivalDelayGroups), MIN(Distance) FROM mytable WHERE DestCityMarketID BETWEEN 31337 AND 35389 OR DivDistance BETWEEN 575 AND 971 AND (DivWheelsOns__MV0 IN (1228, 1007) OR DivWheelsOns__MV1 IN (1228, 1007) OR DivWheelsOns__MV2 IN (1228, 1007) OR DivWheelsOns__MV3 IN (1228, 1007) [...]
+{"sql":"SELECT AVG(CRSArrTime), AVG(DivAirportLandings), MIN(FirstDepTime) FROM mytable WHERE DivActualElapsedTime IN (455, 172, 234, 141) OR DivAirports BETWEEN 'OKC' AND 'SGF' OR DivDistance <> 68 LIMIT 24","hsqls":["SELECT AVG(CRSArrTime), AVG(DivAirportLandings), MIN(FirstDepTime) FROM mytable WHERE DivActualElapsedTime IN (455, 172, 234, 141) OR (DivAirports__MV0 BETWEEN 'OKC' AND 'SGF' OR DivAirports__MV1 BETWEEN 'OKC' AND 'SGF' OR DivAirports__MV2 BETWEEN 'OKC' AND 'SGF' OR DivAi [...]
+{"sql":"SELECT AVG(CRSDepTime), MIN(DivReachedDest) FROM mytable WHERE \"Year\" = 2014 OR Origin BETWEEN 'MLU' AND 'BDL' OR DestStateFips > 18 LIMIT 22","hsqls":["SELECT AVG(CRSDepTime), MIN(DivReachedDest) FROM mytable WHERE Year = 2014 OR Origin BETWEEN 'MLU' AND 'BDL' OR DestStateFips > 18 LIMIT 22"]}
+{"sql":"SELECT AVG(CarrierDelay), AVG(OriginCityMarketID), MAX(ArrTime) FROM mytable WHERE \"Year\" BETWEEN 2014 AND 2014 OR AirlineID <= 20398 LIMIT 14","hsqls":["SELECT AVG(CarrierDelay), AVG(OriginCityMarketID), MAX(ArrTime) FROM mytable WHERE Year BETWEEN 2014 AND 2014 OR AirlineID <= 20398 LIMIT 14"]}
+{"sql":"SELECT AVG(DayOfWeek) FROM mytable WHERE DivTailNums IN ('N915DE', 'N8612K') LIMIT 3","hsqls":["SELECT AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable WHERE (DivTailNums__MV0 IN ('N915DE', 'N8612K') OR DivTailNums__MV1 IN ('N915DE', 'N8612K') OR DivTailNums__MV2 IN ('N915DE', 'N8612K') OR DivTailNums__MV3 IN ('N915DE', 'N8612K') OR DivTailNums__MV4 IN ('N915DE', 'N8612K')) LIMIT 10000"]}
+{"sql":"SELECT AVG(DayOfWeek), MAX(Diverted) FROM mytable WHERE DivAirportSeqIDs >= 1281902 OR DestAirportSeqID NOT IN (1463502, 1530402, 1068502) AND DepDelayMinutes BETWEEN 48.0 AND 94.0 LIMIT 18","hsqls":["SELECT AVG(DayOfWeek), MAX(Diverted) FROM mytable WHERE (DivAirportSeqIDs__MV0 >= 1281902 OR DivAirportSeqIDs__MV1 >= 1281902 OR DivAirportSeqIDs__MV2 >= 1281902 OR DivAirportSeqIDs__MV3 >= 1281902 OR DivAirportSeqIDs__MV4 >= 1281902) OR DestAirportSeqID NOT IN (1463502, 1530402, 1 [...]
+{"sql":"SELECT AVG(DayofMonth), COUNT(CRSElapsedTime) FROM mytable WHERE LateAircraftDelay BETWEEN 151 AND 72 OR \"Year\" IN (2014) LIMIT 14","hsqls":["SELECT AVG(DayofMonth), COUNT(CRSElapsedTime) FROM mytable WHERE LateAircraftDelay BETWEEN 151 AND 72 OR Year IN (2014) LIMIT 14"]}
+{"sql":"SELECT AVG(DaysSinceEpoch) FROM mytable WHERE DivAirportIDs > 14027 AND DivLongestGTimes >= 61.0 AND Cancelled BETWEEN 0 AND 1 LIMIT 3","hsqls":["SELECT AVG(CAST(DaysSinceEpoch AS DOUBLE)) FROM mytable WHERE (DivAirportIDs__MV0 > 14027 OR DivAirportIDs__MV1 > 14027 OR DivAirportIDs__MV2 > 14027 OR DivAirportIDs__MV3 > 14027 OR DivAirportIDs__MV4 > 14027) AND (DivLongestGTimes__MV0 >= 61.0 OR DivLongestGTimes__MV1 >= 61.0 OR DivLongestGTimes__MV2 >= 61.0 OR DivLongestGTimes__MV3 > [...]
+{"sql":"SELECT AVG(DepDel15), COUNT(Cancelled) FROM mytable WHERE Cancelled BETWEEN 0 AND 1 AND DivAirports IN ('GNV', 'MRY', 'PUB', 'PIA', 'MAF') LIMIT 29","hsqls":["SELECT AVG(DepDel15), COUNT(Cancelled) FROM mytable WHERE Cancelled BETWEEN 0 AND 1 AND (DivAirports__MV0 IN ('GNV', 'MRY', 'PUB', 'PIA', 'MAF') OR DivAirports__MV1 IN ('GNV', 'MRY', 'PUB', 'PIA', 'MAF') OR DivAirports__MV2 IN ('GNV', 'MRY', 'PUB', 'PIA', 'MAF') OR DivAirports__MV3 IN ('GNV', 'MRY', 'PUB', 'PIA', 'MAF') OR [...]
+{"sql":"SELECT AVG(DepDelay), AVG(Diverted), SUM(DestAirportSeqID) FROM mytable WHERE OriginCityMarketID >= 31123 OR OriginWac >= 43 OR DivAirportIDs BETWEEN 12323 AND 13487 LIMIT 1","hsqls":["SELECT AVG(DepDelay), AVG(Diverted), SUM(DestAirportSeqID) FROM mytable WHERE OriginCityMarketID >= 31123 OR OriginWac >= 43 OR (DivAirportIDs__MV0 BETWEEN 12323 AND 13487 OR DivAirportIDs__MV1 BETWEEN 12323 AND 13487 OR DivAirportIDs__MV2 BETWEEN 12323 AND 13487 OR DivAirportIDs__MV3 BETWEEN 1232 [...]
+{"sql":"SELECT AVG(DepDelay), COUNT(WheelsOff), SUM(DivDistance) FROM mytable WHERE DivLongestGTimes IN (53.0, 6.0, 65.0, 21.0, 8.0) AND OriginStateFips >= 30 AND OriginWac = 87 LIMIT 19","hsqls":["SELECT AVG(DepDelay), COUNT(WheelsOff), SUM(DivDistance) FROM mytable WHERE (DivLongestGTimes__MV0 IN (53.0, 6.0, 65.0, 21.0, 8.0) OR DivLongestGTimes__MV1 IN (53.0, 6.0, 65.0, 21.0, 8.0) OR DivLongestGTimes__MV2 IN (53.0, 6.0, 65.0, 21.0, 8.0) OR DivLongestGTimes__MV3 IN (53.0, 6.0, 65.0, 21 [...]
+{"sql":"SELECT AVG(DestAirportID) FROM mytable WHERE DestCityMarketID BETWEEN 30476 AND 31481 AND DivTailNums BETWEEN 'N118US' AND 'N962SW' AND DistanceGroup <= 7 LIMIT 10","hsqls":["SELECT AVG(CAST(DestAirportID AS DOUBLE)) FROM mytable WHERE DestCityMarketID BETWEEN 30476 AND 31481 AND (DivTailNums__MV0 BETWEEN 'N118US' AND 'N962SW' OR DivTailNums__MV1 BETWEEN 'N118US' AND 'N962SW' OR DivTailNums__MV2 BETWEEN 'N118US' AND 'N962SW' OR DivTailNums__MV3 BETWEEN 'N118US' AND 'N962SW' OR Di [...]
+{"sql":"SELECT AVG(DestAirportID), COUNT(DepartureDelayGroups), MIN(LongestAddGTime) FROM mytable WHERE DivAirports IN ('GGG') LIMIT 3","hsqls":["SELECT AVG(DestAirportID), COUNT(DepartureDelayGroups), MIN(LongestAddGTime) FROM mytable WHERE (DivAirports__MV0 IN ('GGG') OR DivAirports__MV1 IN ('GGG') OR DivAirports__MV2 IN ('GGG') OR DivAirports__MV3 IN ('GGG') OR DivAirports__MV4 IN ('GGG')) LIMIT 10000"]}
+{"sql":"SELECT AVG(OriginAirportSeqID), MIN(CarrierDelay), SUM(Quarter) FROM mytable WHERE DivAirportSeqIDs BETWEEN 1039705 AND 1315802 LIMIT 24","hsqls":["SELECT AVG(OriginAirportSeqID), MIN(CarrierDelay), SUM(Quarter) FROM mytable WHERE (DivAirportSeqIDs__MV0 BETWEEN 1039705 AND 1315802 OR DivAirportSeqIDs__MV1 BETWEEN 1039705 AND 1315802 OR DivAirportSeqIDs__MV2 BETWEEN 1039705 AND 1315802 OR DivAirportSeqIDs__MV3 BETWEEN 1039705 AND 1315802 OR DivAirportSeqIDs__MV4 BETWEEN 1039705 A [...]
+{"sql":"SELECT AVG(OriginStateFips) FROM mytable WHERE DivAirports IN ('OGG') OR DivAirportLandings < 0 LIMIT 26","hsqls":["SELECT AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable WHERE (DivAirports__MV0 IN ('OGG') OR DivAirports__MV1 IN ('OGG') OR DivAirports__MV2 IN ('OGG') OR DivAirports__MV3 IN ('OGG') OR DivAirports__MV4 IN ('OGG')) OR DivAirportLandings < 0 LIMIT 10000"]}
+{"sql":"SELECT AVG(OriginStateFips) FROM mytable WHERE DivDistance IN (261, 176, 60, 283) AND OriginAirportSeqID BETWEEN 1043403 AND 1325602 LIMIT 16"}
+{"sql":"SELECT AVG(OriginStateFips) FROM mytable WHERE FlightDate IN ('2014-01-01') OR LongestAddGTime >= 148 AND OriginStateName IN ('New Hampshire', 'Minnesota', 'Mississippi', 'West Virginia', 'Oklahoma') LIMIT 13"}
+{"sql":"SELECT AVG(OriginWac), MAX(DistanceGroup), MAX(Quarter) FROM mytable WHERE ArrDel15 NOT IN (1, 0, -9999) AND NASDelay IN (39) OR DivWheelsOffs <= 1742 LIMIT 25","hsqls":["SELECT AVG(OriginWac), MAX(DistanceGroup), MAX(Quarter) FROM mytable WHERE ArrDel15 NOT IN (1, 0, -9999) AND NASDelay IN (39) OR (DivWheelsOffs__MV0 <= 1742 OR DivWheelsOffs__MV1 <= 1742 OR DivWheelsOffs__MV2 <= 1742 OR DivWheelsOffs__MV3 <= 1742 OR DivWheelsOffs__MV4 <= 1742) LIMIT 10000"]}
+{"sql":"SELECT AVG(Quarter) FROM mytable WHERE ArrDelayMinutes IN (180.0, 189.0, 153.0, 135.0) OR FlightNum NOT IN (16, 2203) AND DivAirportSeqIDs BETWEEN 1228002 AND 1481402 LIMIT 19","hsqls":["SELECT AVG(CAST(Quarter AS DOUBLE)) FROM mytable WHERE ArrDelayMinutes IN (180.0, 189.0, 153.0, 135.0) OR FlightNum NOT IN (16, 2203) AND (DivAirportSeqIDs__MV0 BETWEEN 1228002 AND 1481402 OR DivAirportSeqIDs__MV1 BETWEEN 1228002 AND 1481402 OR DivAirportSeqIDs__MV2 BETWEEN 1228002 AND 1481402 OR [...]
+{"sql":"SELECT AVG(SecurityDelay) FROM mytable WHERE DivAirportSeqIDs BETWEEN 1426202 AND 1486903 OR CRSDepTime NOT IN (919, 1039) LIMIT 19","hsqls":["SELECT AVG(CAST(SecurityDelay AS DOUBLE)) FROM mytable WHERE (DivAirportSeqIDs__MV0 BETWEEN 1426202 AND 1486903 OR DivAirportSeqIDs__MV1 BETWEEN 1426202 AND 1486903 OR DivAirportSeqIDs__MV2 BETWEEN 1426202 AND 1486903 OR DivAirportSeqIDs__MV3 BETWEEN 1426202 AND 1486903 OR DivAirportSeqIDs__MV4 BETWEEN 1426202 AND 1486903) OR CRSDepTime NO [...]
+{"sql":"SELECT AVG(SecurityDelay), MAX(LateAircraftDelay) FROM mytable WHERE ArrivalDelayGroups BETWEEN 0 AND 3 OR DivAirportIDs IN (14314) LIMIT 23","hsqls":["SELECT AVG(SecurityDelay), MAX(LateAircraftDelay) FROM mytable WHERE ArrivalDelayGroups BETWEEN 0 AND 3 OR (DivAirportIDs__MV0 IN (14314) OR DivAirportIDs__MV1 IN (14314) OR DivAirportIDs__MV2 IN (14314) OR DivAirportIDs__MV3 IN (14314) OR DivAirportIDs__MV4 IN (14314)) LIMIT 10000"]}
+{"sql":"SELECT AVG(TaxiIn) FROM mytable WHERE \"Year\" BETWEEN 2014 AND 2014 AND DivReachedDest BETWEEN -9999 AND 1 LIMIT 11","hsqls":["SELECT AVG(TaxiIn) FROM mytable WHERE Year BETWEEN 2014 AND 2014 AND DivReachedDest BETWEEN -9999 AND 1 LIMIT 11"]}
+{"sql":"SELECT AVG(TaxiIn), SUM(DestWac), AVG(DivAirportLandings) FROM mytable WHERE DivWheelsOffs BETWEEN 1217 AND 1849 OR DivActualElapsedTime BETWEEN 350 AND 399 OR DestAirportID BETWEEN 12992 AND 10666 LIMIT 28","hsqls":["SELECT AVG(TaxiIn), SUM(DestWac), AVG(DivAirportLandings) FROM mytable WHERE (DivWheelsOffs__MV0 BETWEEN 1217 AND 1849 OR DivWheelsOffs__MV1 BETWEEN 1217 AND 1849 OR DivWheelsOffs__MV2 BETWEEN 1217 AND 1849 OR DivWheelsOffs__MV3 BETWEEN 1217 AND 1849 OR DivWheelsOf [...]
+{"sql":"SELECT AVG(TotalAddGTime), AVG(CarrierDelay), MAX(OriginCityMarketID) FROM mytable WHERE DivTotalGTimes IN (68, 112, 18, 80, 26) LIMIT 9","hsqls":["SELECT AVG(TotalAddGTime), AVG(CarrierDelay), MAX(OriginCityMarketID) FROM mytable WHERE (DivTotalGTimes__MV0 IN (68, 112, 18, 80, 26) OR DivTotalGTimes__MV1 IN (68, 112, 18, 80, 26) OR DivTotalGTimes__MV2 IN (68, 112, 18, 80, 26) OR DivTotalGTimes__MV3 IN (68, 112, 18, 80, 26) OR DivTotalGTimes__MV4 IN (68, 112, 18, 80, 26)) LIMIT 10000"]}
+{"sql":"SELECT AVG(TotalAddGTime), MAX(OriginStateFips) FROM mytable WHERE \"Year\" NOT IN (2014) OR ArrDelay BETWEEN -30.0 AND 31.0 AND DayOfWeek NOT IN (6, 5) LIMIT 15","hsqls":["SELECT AVG(TotalAddGTime), MAX(OriginStateFips) FROM mytable WHERE Year NOT IN (2014) OR ArrDelay BETWEEN -30.0 AND 31.0 AND DayOfWeek NOT IN (6, 5) LIMIT 15"]}
+{"sql":"SELECT AVG(TotalAddGTime), SUM(ArrivalDelayGroups), SUM(SecurityDelay) FROM mytable WHERE UniqueCarrier = 'AA' OR Cancelled IN (1, 0) OR DivWheelsOffs BETWEEN 1719 AND 1720 LIMIT 16","hsqls":["SELECT AVG(TotalAddGTime), SUM(ArrivalDelayGroups), SUM(SecurityDelay) FROM mytable WHERE UniqueCarrier = 'AA' OR Cancelled IN (1, 0) OR (DivWheelsOffs__MV0 BETWEEN 1719 AND 1720 OR DivWheelsOffs__MV1 BETWEEN 1719 AND 1720 OR DivWheelsOffs__MV2 BETWEEN 1719 AND 1720 OR DivWheelsOffs__MV3 B [...]
+{"sql":"SELECT AVG(WeatherDelay), MIN(ArrTime) FROM mytable WHERE TaxiIn < 162 OR DivAirports >= 'SIT' OR OriginWac BETWEEN 1 AND 71 LIMIT 21","hsqls":["SELECT AVG(WeatherDelay), MIN(ArrTime) FROM mytable WHERE TaxiIn < 162 OR (DivAirports__MV0 >= 'SIT' OR DivAirports__MV1 >= 'SIT' OR DivAirports__MV2 >= 'SIT' OR DivAirports__MV3 >= 'SIT' OR DivAirports__MV4 >= 'SIT') OR OriginWac BETWEEN 1 AND 71 LIMIT 10000"]}
+{"sql":"SELECT AVG(\"Month\"), COUNT(Carrier) FROM mytable WHERE DivLongestGTimes BETWEEN 16.0 AND 118.0 OR DivWheelsOns BETWEEN 1848 AND 2330 LIMIT 29","hsqls":["SELECT AVG(Month), COUNT(Carrier) FROM mytable WHERE (DivLongestGTimes__MV0 BETWEEN 16.0 AND 118.0 OR DivLongestGTimes__MV1 BETWEEN 16.0 AND 118.0 OR DivLongestGTimes__MV2 BETWEEN 16.0 AND 118.0 OR DivLongestGTimes__MV3 BETWEEN 16.0 AND 118.0 OR DivLongestGTimes__MV4 BETWEEN 16.0 AND 118.0) OR (DivWheelsOns__MV0 BETWEEN 1848 A [...]
+{"sql":"SELECT AVG(\"Month\"), COUNT(DepDelay), MAX(LongestAddGTime) FROM mytable WHERE FlightDate = '2014-01-26' OR OriginAirportID < 11433 AND AirlineID NOT IN (20304, 20355) LIMIT 27","hsqls":["SELECT AVG(Month), COUNT(DepDelay), MAX(LongestAddGTime) FROM mytable WHERE FlightDate = '2014-01-26' OR OriginAirportID < 11433 AND AirlineID NOT IN (20304, 20355) LIMIT 27"]}
+{"sql":"SELECT AVG(\"Year\"), COUNT(Dest) FROM mytable WHERE OriginState > 'GA' LIMIT 13","hsqls":["SELECT AVG(Year), COUNT(Dest) FROM mytable WHERE OriginState > 'GA' LIMIT 13"]}
+{"sql":"SELECT AVG(\"Year\"), MAX(DaysSinceEpoch), MAX(CarrierDelay) FROM mytable WHERE Origin BETWEEN 'GEG' AND 'ORH'","hsqls":["SELECT AVG(Year), MAX(DaysSinceEpoch), MAX(CarrierDelay) FROM mytable WHERE Origin BETWEEN 'GEG' AND 'ORH'"]}
+{"sql":"SELECT AVG(\"Year\"), MAX(WheelsOn), AVG(Cancelled) FROM mytable WHERE ArrDelayMinutes BETWEEN 106.0 AND 224.0 OR DestWac IN (65, 83, 72) LIMIT 14","hsqls":["SELECT AVG(Year), MAX(WheelsOn), AVG(Cancelled) FROM mytable WHERE ArrDelayMinutes BETWEEN 106.0 AND 224.0 OR DestWac IN (65, 83, 72) LIMIT 14"]}
+{"sql":"SELECT AVG(\"Year\"), MIN(AirTime) FROM mytable WHERE Diverted BETWEEN 0 AND 1 AND CarrierDelay IN (149, 72, 86) AND ArrivalDelayGroups IN (1, 7, 4, 11) LIMIT 12","hsqls":["SELECT AVG(Year), MIN(AirTime) FROM mytable WHERE Diverted BETWEEN 0 AND 1 AND CarrierDelay IN (149, 72, 86) AND ArrivalDelayGroups IN (1, 7, 4, 11) LIMIT 12"]}
+{"sql":"SELECT AVG(\"Year\"), SUM(ArrivalDelayGroups), MAX(DepartureDelayGroups) FROM mytable WHERE DivWheelsOffs IN (1702, 2226, 749, 2328, 844) OR ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 2","hsqls":["SELECT AVG(Year), SUM(ArrivalDelayGroups), MAX(DepartureDelayGroups) FROM mytable WHERE (DivWheelsOffs__MV0 IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV1 IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV2 IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV3 IN [...]
+{"sql":"SELECT COUNT(*) FROM mytable WHERE ActualElapsedTime NOT IN (90, 178, 247, 118, 119) OR DistanceGroup BETWEEN 10 AND 4 AND DivAirportSeqIDs BETWEEN 1252302 AND 1232303 LIMIT 4","hsqls":["SELECT COUNT(*) FROM mytable WHERE ActualElapsedTime NOT IN (90, 178, 247, 118, 119) OR DistanceGroup BETWEEN 10 AND 4 AND (DivAirportSeqIDs__MV0 BETWEEN 1252302 AND 1232303 OR DivAirportSeqIDs__MV1 BETWEEN 1252302 AND 1232303 OR DivAirportSeqIDs__MV2 BETWEEN 1252302 AND 1232303 OR DivAirportSeqI [...]
+{"sql":"SELECT COUNT(*) FROM mytable WHERE ArrDelayMinutes BETWEEN 125.0 AND 83.0 OR DivWheelsOffs BETWEEN 2307 AND 923 LIMIT 27","hsqls":["SELECT COUNT(*) FROM mytable WHERE ArrDelayMinutes BETWEEN 125.0 AND 83.0 OR (DivWheelsOffs__MV0 BETWEEN 2307 AND 923 OR DivWheelsOffs__MV1 BETWEEN 2307 AND 923 OR DivWheelsOffs__MV2 BETWEEN 2307 AND 923 OR DivWheelsOffs__MV3 BETWEEN 2307 AND 923 OR DivWheelsOffs__MV4 BETWEEN 2307 AND 923) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE ArrDelayMinutes NOT IN (105.0) OR DivAirportSeqIDs BETWEEN 1040802 AND 1610102 LIMIT 23","hsqls":["SELECT COUNT(*) FROM mytable WHERE ArrDelayMinutes NOT IN (105.0) OR (DivAirportSeqIDs__MV0 BETWEEN 1040802 AND 1610102 OR DivAirportSeqIDs__MV1 BETWEEN 1040802 AND 1610102 OR DivAirportSeqIDs__MV2 BETWEEN 1040802 AND 1610102 OR DivAirportSeqIDs__MV3 BETWEEN 1040802 AND 1610102 OR DivAirportSeqIDs__MV4 BETWEEN 1040802 AND 1610102) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE ArrTimeBlk IN ('1700-1759', '1300-1359', '1000-1059') AND DivLongestGTimes >= 21.0 LIMIT 3","hsqls":["SELECT COUNT(*) FROM mytable WHERE ArrTimeBlk IN ('1700-1759', '1300-1359', '1000-1059') AND (DivLongestGTimes__MV0 >= 21.0 OR DivLongestGTimes__MV1 >= 21.0 OR DivLongestGTimes__MV2 >= 21.0 OR DivLongestGTimes__MV3 >= 21.0 OR DivLongestGTimes__MV4 >= 21.0) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE ArrTimeBlk NOT IN ('0700-0759', '0800-0859', '1200-1259') AND OriginAirportSeqID IN (1182304, 1419303) OR OriginStateFips NOT IN (2, 30, 55, 50) LIMIT 7"}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE ArrivalDelayGroups >= 2 OR OriginStateName IN ('Mississippi', 'Idaho', 'Hawaii') AND DivDistance BETWEEN 302 AND 254 LIMIT 12"}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE ArrivalDelayGroups >= 3 OR DivArrDelay NOT IN (1280, 252, 647, 71, 166) OR NASDelay IN (133, 35, 63, -9999, 12) LIMIT 16"}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE ArrivalDelayGroups BETWEEN 9 AND 11 AND DivTailNums < 'N13903' LIMIT 11","hsqls":["SELECT COUNT(*) FROM mytable WHERE ArrivalDelayGroups BETWEEN 9 AND 11 AND (DivTailNums__MV0 < 'N13903' OR DivTailNums__MV1 < 'N13903' OR DivTailNums__MV2 < 'N13903' OR DivTailNums__MV3 < 'N13903' OR DivTailNums__MV4 < 'N13903') LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE CRSArrTime <= 1412 AND DivLongestGTimes BETWEEN 69.0 AND 1.0 OR ActualElapsedTime BETWEEN 304 AND 336 LIMIT 15","hsqls":["SELECT COUNT(*) FROM mytable WHERE CRSArrTime <= 1412 AND (DivLongestGTimes__MV0 BETWEEN 69.0 AND 1.0 OR DivLongestGTimes__MV1 BETWEEN 69.0 AND 1.0 OR DivLongestGTimes__MV2 BETWEEN 69.0 AND 1.0 OR DivLongestGTimes__MV3 BETWEEN 69.0 AND 1.0 OR DivLongestGTimes__MV4 BETWEEN 69.0 AND 1.0) OR ActualElapsedTime BETWEEN 304 AND 336 [...]
+{"sql":"SELECT COUNT(*) FROM mytable WHERE CRSArrTime <> 1940 OR DivTailNums > 'N854AS' AND DayOfWeek NOT IN (3, 1, 6) LIMIT 15","hsqls":["SELECT COUNT(*) FROM mytable WHERE CRSArrTime <> 1940 OR (DivTailNums__MV0 > 'N854AS' OR DivTailNums__MV1 > 'N854AS' OR DivTailNums__MV2 > 'N854AS' OR DivTailNums__MV3 > 'N854AS' OR DivTailNums__MV4 > 'N854AS') AND DayOfWeek NOT IN (3, 1, 6) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE CRSArrTime BETWEEN 2113 AND 1527 OR OriginAirportSeqID NOT IN (1336703, 1245102, 1104202, 1541103) LIMIT 8"}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE CRSArrTime NOT IN (2109, 1158, 1750) AND DivTotalGTimes BETWEEN 45 AND 8 AND ArrDelay BETWEEN 173.0 AND 158.0 LIMIT 26","hsqls":["SELECT COUNT(*) FROM mytable WHERE CRSArrTime NOT IN (2109, 1158, 1750) AND (DivTotalGTimes__MV0 BETWEEN 45 AND 8 OR DivTotalGTimes__MV1 BETWEEN 45 AND 8 OR DivTotalGTimes__MV2 BETWEEN 45 AND 8 OR DivTotalGTimes__MV3 BETWEEN 45 AND 8 OR DivTotalGTimes__MV4 BETWEEN 45 AND 8) AND ArrDelay BETWEEN 173.0 AND 158.0 LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE CRSElapsedTime BETWEEN 374 AND 370 OR \"Month\" NOT IN (1) LIMIT 8","hsqls":["SELECT COUNT(*) FROM mytable WHERE CRSElapsedTime BETWEEN 374 AND 370 OR Month NOT IN (1) LIMIT 8"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE CRSElapsedTime NOT IN (145, 213, 341, 74) OR ArrTimeBlk BETWEEN '2000-2059' AND '0600-0659' OR \"Year\" BETWEEN 2014 AND 2014 LIMIT 27","hsqls":["SELECT COUNT(*) FROM mytable WHERE CRSElapsedTime NOT IN (145, 213, 341, 74) OR ArrTimeBlk BETWEEN '2000-2059' AND '0600-0659' OR Year BETWEEN 2014 AND 2014 LIMIT 27"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE Cancelled BETWEEN 1 AND 0 AND DivAirportSeqIDs >= 1221702 OR DestWac BETWEEN 3 AND 83 LIMIT 5","hsqls":["SELECT COUNT(*) FROM mytable WHERE Cancelled BETWEEN 1 AND 0 AND (DivAirportSeqIDs__MV0 >= 1221702 OR DivAirportSeqIDs__MV1 >= 1221702 OR DivAirportSeqIDs__MV2 >= 1221702 OR DivAirportSeqIDs__MV3 >= 1221702 OR DivAirportSeqIDs__MV4 >= 1221702) OR DestWac BETWEEN 3 AND 83 LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE Cancelled BETWEEN 1 AND 0 OR DivLongestGTimes BETWEEN 47.0 AND 95.0 OR OriginCityMarketID <> 34524 LIMIT 6","hsqls":["SELECT COUNT(*) FROM mytable WHERE Cancelled BETWEEN 1 AND 0 OR (DivLongestGTimes__MV0 BETWEEN 47.0 AND 95.0 OR DivLongestGTimes__MV1 BETWEEN 47.0 AND 95.0 OR DivLongestGTimes__MV2 BETWEEN 47.0 AND 95.0 OR DivLongestGTimes__MV3 BETWEEN 47.0 AND 95.0 OR DivLongestGTimes__MV4 BETWEEN 47.0 AND 95.0) OR OriginCityMarketID <> 34524 LI [...]
+{"sql":"SELECT COUNT(*) FROM mytable WHERE Dest BETWEEN 'LIH' AND 'RHI' OR DivAirportIDs BETWEEN 13277 AND 14252 LIMIT 3","hsqls":["SELECT COUNT(*) FROM mytable WHERE Dest BETWEEN 'LIH' AND 'RHI' OR (DivAirportIDs__MV0 BETWEEN 13277 AND 14252 OR DivAirportIDs__MV1 BETWEEN 13277 AND 14252 OR DivAirportIDs__MV2 BETWEEN 13277 AND 14252 OR DivAirportIDs__MV3 BETWEEN 13277 AND 14252 OR DivAirportIDs__MV4 BETWEEN 13277 AND 14252) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DestAirportSeqID IN (1153703) OR \"Year\" NOT IN (2014) OR CRSArrTime IN (1655, 740, 18, 248) LIMIT 5","hsqls":["SELECT COUNT(*) FROM mytable WHERE DestAirportSeqID IN (1153703) OR Year NOT IN (2014) OR CRSArrTime IN (1655, 740, 18, 248) LIMIT 5"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DistanceGroup NOT IN (2, 7, 5, 4, 11) OR WheelsOn > 2221 OR CarrierDelay BETWEEN 0 AND 58 LIMIT 9"}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivActualElapsedTime = 891 AND DivAirports = 'DAY' LIMIT 17","hsqls":["SELECT COUNT(*) FROM mytable WHERE DivActualElapsedTime = 891 AND (DivAirports__MV0 = 'DAY' OR DivAirports__MV1 = 'DAY' OR DivAirports__MV2 = 'DAY' OR DivAirports__MV3 = 'DAY' OR DivAirports__MV4 = 'DAY') LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivLongestGTimes < 139.0 LIMIT 8","hsqls":["SELECT COUNT(*) FROM mytable WHERE (DivLongestGTimes__MV0 < 139.0 OR DivLongestGTimes__MV1 < 139.0 OR DivLongestGTimes__MV2 < 139.0 OR DivLongestGTimes__MV3 < 139.0 OR DivLongestGTimes__MV4 < 139.0) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivTailNums <= 'N336AA' AND DivAirports IN ('PHL', 'ROA', 'MSY', 'ONT', 'CWA') LIMIT 19","hsqls":["SELECT COUNT(*) FROM mytable WHERE (DivTailNums__MV0 <= 'N336AA' OR DivTailNums__MV1 <= 'N336AA' OR DivTailNums__MV2 <= 'N336AA' OR DivTailNums__MV3 <= 'N336AA' OR DivTailNums__MV4 <= 'N336AA') AND (DivAirports__MV0 IN ('PHL', 'ROA', 'MSY', 'ONT', 'CWA') OR DivAirports__MV1 IN ('PHL', 'ROA', 'MSY', 'ONT', 'CWA') OR DivAirports__MV2 IN ('PHL', 'ROA' [...]
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivTailNums <= 'N796SK' LIMIT 5","hsqls":["SELECT COUNT(*) FROM mytable WHERE (DivTailNums__MV0 <= 'N796SK' OR DivTailNums__MV1 <= 'N796SK' OR DivTailNums__MV2 <= 'N796SK' OR DivTailNums__MV3 <= 'N796SK' OR DivTailNums__MV4 <= 'N796SK') LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivTailNums BETWEEN 'N821SK' AND 'N699BR'","hsqls":["SELECT COUNT(*) FROM mytable WHERE (DivTailNums__MV0 BETWEEN 'N821SK' AND 'N699BR' OR DivTailNums__MV1 BETWEEN 'N821SK' AND 'N699BR' OR DivTailNums__MV2 BETWEEN 'N821SK' AND 'N699BR' OR DivTailNums__MV3 BETWEEN 'N821SK' AND 'N699BR' OR DivTailNums__MV4 BETWEEN 'N821SK' AND 'N699BR') LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivTailNums IN ('N393HA', 'N284JB') OR DivActualElapsedTime BETWEEN 290 AND 474 LIMIT 6","hsqls":["SELECT COUNT(*) FROM mytable WHERE (DivTailNums__MV0 IN ('N393HA', 'N284JB') OR DivTailNums__MV1 IN ('N393HA', 'N284JB') OR DivTailNums__MV2 IN ('N393HA', 'N284JB') OR DivTailNums__MV3 IN ('N393HA', 'N284JB') OR DivTailNums__MV4 IN ('N393HA', 'N284JB')) OR DivActualElapsedTime BETWEEN 290 AND 474 LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivTotalGTimes <= 116 LIMIT 6","hsqls":["SELECT COUNT(*) FROM mytable WHERE (DivTotalGTimes__MV0 <= 116 OR DivTotalGTimes__MV1 <= 116 OR DivTotalGTimes__MV2 <= 116 OR DivTotalGTimes__MV3 <= 116 OR DivTotalGTimes__MV4 <= 116) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivTotalGTimes BETWEEN 42 AND 10 OR DepDelay > 154.0 LIMIT 15","hsqls":["SELECT COUNT(*) FROM mytable WHERE (DivTotalGTimes__MV0 BETWEEN 42 AND 10 OR DivTotalGTimes__MV1 BETWEEN 42 AND 10 OR DivTotalGTimes__MV2 BETWEEN 42 AND 10 OR DivTotalGTimes__MV3 BETWEEN 42 AND 10 OR DivTotalGTimes__MV4 BETWEEN 42 AND 10) OR DepDelay > 154.0 LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivTotalGTimes BETWEEN 64 AND 2 OR TaxiIn <= 32 AND DistanceGroup <> 8 LIMIT 5","hsqls":["SELECT COUNT(*) FROM mytable WHERE (DivTotalGTimes__MV0 BETWEEN 64 AND 2 OR DivTotalGTimes__MV1 BETWEEN 64 AND 2 OR DivTotalGTimes__MV2 BETWEEN 64 AND 2 OR DivTotalGTimes__MV3 BETWEEN 64 AND 2 OR DivTotalGTimes__MV4 BETWEEN 64 AND 2) OR TaxiIn <= 32 AND DistanceGroup <> 8 LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivWheelsOffs <= 2313 LIMIT 25","hsqls":["SELECT COUNT(*) FROM mytable WHERE (DivWheelsOffs__MV0 <= 2313 OR DivWheelsOffs__MV1 <= 2313 OR DivWheelsOffs__MV2 <= 2313 OR DivWheelsOffs__MV3 <= 2313 OR DivWheelsOffs__MV4 <= 2313) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE DivWheelsOffs BETWEEN 1605 AND 1239 LIMIT 10","hsqls":["SELECT COUNT(*) FROM mytable WHERE (DivWheelsOffs__MV0 BETWEEN 1605 AND 1239 OR DivWheelsOffs__MV1 BETWEEN 1605 AND 1239 OR DivWheelsOffs__MV2 BETWEEN 1605 AND 1239 OR DivWheelsOffs__MV3 BETWEEN 1605 AND 1239 OR DivWheelsOffs__MV4 BETWEEN 1605 AND 1239) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE OriginStateName > 'Arizona' OR DivAirportIDs BETWEEN 13232 AND 12217 LIMIT 5","hsqls":["SELECT COUNT(*) FROM mytable WHERE OriginStateName > 'Arizona' OR (DivAirportIDs__MV0 BETWEEN 13232 AND 12217 OR DivAirportIDs__MV1 BETWEEN 13232 AND 12217 OR DivAirportIDs__MV2 BETWEEN 13232 AND 12217 OR DivAirportIDs__MV3 BETWEEN 13232 AND 12217 OR DivAirportIDs__MV4 BETWEEN 13232 AND 12217) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE SecurityDelay BETWEEN 27 AND 27 OR DepDel15 BETWEEN -9999 AND 1 AND DivLongestGTimes IN (19.0, 32.0) LIMIT 3","hsqls":["SELECT COUNT(*) FROM mytable WHERE SecurityDelay BETWEEN 27 AND 27 OR DepDel15 BETWEEN -9999 AND 1 AND (DivLongestGTimes__MV0 IN (19.0, 32.0) OR DivLongestGTimes__MV1 IN (19.0, 32.0) OR DivLongestGTimes__MV2 IN (19.0, 32.0) OR DivLongestGTimes__MV3 IN (19.0, 32.0) OR DivLongestGTimes__MV4 IN (19.0, 32.0)) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE TaxiIn IN (31, 55) AND DivLongestGTimes > 2.0 LIMIT 2","hsqls":["SELECT COUNT(*) FROM mytable WHERE TaxiIn IN (31, 55) AND (DivLongestGTimes__MV0 > 2.0 OR DivLongestGTimes__MV1 > 2.0 OR DivLongestGTimes__MV2 > 2.0 OR DivLongestGTimes__MV3 > 2.0 OR DivLongestGTimes__MV4 > 2.0) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE TotalAddGTime IN (32, 19) OR TailNum NOT IN ('N563UA', 'N3749D', 'N216AG', 'N543US', 'N829UA') OR DivLongestGTimes = 15.0 LIMIT 18","hsqls":["SELECT COUNT(*) FROM mytable WHERE TotalAddGTime IN (32, 19) OR TailNum NOT IN ('N563UA', 'N3749D', 'N216AG', 'N543US', 'N829UA') OR (DivLongestGTimes__MV0 = 15.0 OR DivLongestGTimes__MV1 = 15.0 OR DivLongestGTimes__MV2 = 15.0 OR DivLongestGTimes__MV3 = 15.0 OR DivLongestGTimes__MV4 = 15.0) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE UniqueCarrier BETWEEN 'WN' AND 'FL' OR DivAirportSeqIDs > 1164802 LIMIT 8","hsqls":["SELECT COUNT(*) FROM mytable WHERE UniqueCarrier BETWEEN 'WN' AND 'FL' OR (DivAirportSeqIDs__MV0 > 1164802 OR DivAirportSeqIDs__MV1 > 1164802 OR DivAirportSeqIDs__MV2 > 1164802 OR DivAirportSeqIDs__MV3 > 1164802 OR DivAirportSeqIDs__MV4 > 1164802) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE WheelsOff >= 1841 AND DivTotalGTimes BETWEEN 21 AND 11 LIMIT 24","hsqls":["SELECT COUNT(*) FROM mytable WHERE WheelsOff >= 1841 AND (DivTotalGTimes__MV0 BETWEEN 21 AND 11 OR DivTotalGTimes__MV1 BETWEEN 21 AND 11 OR DivTotalGTimes__MV2 BETWEEN 21 AND 11 OR DivTotalGTimes__MV3 BETWEEN 21 AND 11 OR DivTotalGTimes__MV4 BETWEEN 21 AND 11) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE \"Year\" BETWEEN 2014 AND 2014 AND DestCityName IN ('Chattanooga, TN', 'New York, NY') LIMIT 29","hsqls":["SELECT COUNT(*) FROM mytable WHERE Year BETWEEN 2014 AND 2014 AND DestCityName IN ('Chattanooga, TN', 'New York, NY') LIMIT 29"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE \"Year\" BETWEEN 2014 AND 2014 OR DepTimeBlk BETWEEN '1400-1459' AND '1300-1359' LIMIT 8","hsqls":["SELECT COUNT(*) FROM mytable WHERE Year BETWEEN 2014 AND 2014 OR DepTimeBlk BETWEEN '1400-1459' AND '1300-1359' LIMIT 8"]}
+{"sql":"SELECT COUNT(ActualElapsedTime), AVG(DestWac) FROM mytable WHERE DayOfWeek NOT IN (3, 1, 6, 4) OR DivTotalGTimes IN (62) LIMIT 18","hsqls":["SELECT COUNT(ActualElapsedTime), AVG(DestWac) FROM mytable WHERE DayOfWeek NOT IN (3, 1, 6, 4) OR (DivTotalGTimes__MV0 IN (62) OR DivTotalGTimes__MV1 IN (62) OR DivTotalGTimes__MV2 IN (62) OR DivTotalGTimes__MV3 IN (62) OR DivTotalGTimes__MV4 IN (62)) LIMIT 10000"]}
+{"sql":"SELECT COUNT(AirTime) FROM mytable WHERE Cancelled BETWEEN 0 AND 0 OR DivWheelsOffs BETWEEN 2043 AND 2133 AND FlightNum NOT IN (3228) LIMIT 11","hsqls":["SELECT COUNT(AirTime) FROM mytable WHERE Cancelled BETWEEN 0 AND 0 OR (DivWheelsOffs__MV0 BETWEEN 2043 AND 2133 OR DivWheelsOffs__MV1 BETWEEN 2043 AND 2133 OR DivWheelsOffs__MV2 BETWEEN 2043 AND 2133 OR DivWheelsOffs__MV3 BETWEEN 2043 AND 2133 OR DivWheelsOffs__MV4 BETWEEN 2043 AND 2133) AND FlightNum NOT IN (3228) LIMIT 10000"]}
+{"sql":"SELECT COUNT(CRSElapsedTime) FROM mytable WHERE DivWheelsOffs BETWEEN 1257 AND 325 AND DestState IN ('LA', 'MS') AND \"Month\" BETWEEN 1 AND 1 LIMIT 6","hsqls":["SELECT COUNT(CRSElapsedTime) FROM mytable WHERE (DivWheelsOffs__MV0 BETWEEN 1257 AND 325 OR DivWheelsOffs__MV1 BETWEEN 1257 AND 325 OR DivWheelsOffs__MV2 BETWEEN 1257 AND 325 OR DivWheelsOffs__MV3 BETWEEN 1257 AND 325 OR DivWheelsOffs__MV4 BETWEEN 1257 AND 325) AND DestState IN ('LA', 'MS') AND Month BETWEEN 1 AND 1 LIMI [...]
+{"sql":"SELECT COUNT(Cancelled), MIN(DepDelay) FROM mytable WHERE DivArrDelay BETWEEN 125 AND 278 AND DistanceGroup NOT IN (7, 5, 8, 11) OR \"Month\" BETWEEN 1 AND 1 LIMIT 2","hsqls":["SELECT COUNT(Cancelled), MIN(DepDelay) FROM mytable WHERE DivArrDelay BETWEEN 125 AND 278 AND DistanceGroup NOT IN (7, 5, 8, 11) OR Month BETWEEN 1 AND 1 LIMIT 2"]}
+{"sql":"SELECT COUNT(Carrier) FROM mytable WHERE \"Month\" = 1 OR NASDelay >= 32 LIMIT 20","hsqls":["SELECT COUNT(Carrier) FROM mytable WHERE Month = 1 OR NASDelay >= 32 LIMIT 20"]}
+{"sql":"SELECT COUNT(Carrier), MIN(DivActualElapsedTime), MAX(DepDelayMinutes) FROM mytable WHERE DestCityMarketID NOT IN (31423) OR TaxiOut BETWEEN 24 AND 60 OR DivTotalGTimes BETWEEN 57 AND 76","hsqls":["SELECT COUNT(Carrier), MIN(DivActualElapsedTime), MAX(DepDelayMinutes) FROM mytable WHERE DestCityMarketID NOT IN (31423) OR TaxiOut BETWEEN 24 AND 60 OR (DivTotalGTimes__MV0 BETWEEN 57 AND 76 OR DivTotalGTimes__MV1 BETWEEN 57 AND 76 OR DivTotalGTimes__MV2 BETWEEN 57 AND 76 OR DivTota [...]
+{"sql":"SELECT COUNT(CarrierDelay), SUM(DestAirportID) FROM mytable WHERE DaysSinceEpoch <= 16073 AND DivAirportIDs IN (12278, 12451, 11973, 13424) LIMIT 15","hsqls":["SELECT COUNT(CarrierDelay), SUM(DestAirportID) FROM mytable WHERE DaysSinceEpoch <= 16073 AND (DivAirportIDs__MV0 IN (12278, 12451, 11973, 13424) OR DivAirportIDs__MV1 IN (12278, 12451, 11973, 13424) OR DivAirportIDs__MV2 IN (12278, 12451, 11973, 13424) OR DivAirportIDs__MV3 IN (12278, 12451, 11973, 13424) OR DivAirportID [...]
+{"sql":"SELECT COUNT(DepDel15), AVG(Distance) FROM mytable WHERE OriginCityName > 'Dickinson, ND' OR OriginCityMarketID <= 32467 OR DestStateName BETWEEN 'Illinois' AND 'Idaho' LIMIT 18"}
+{"sql":"SELECT COUNT(DepDel15), MIN(DepDelay), SUM(OriginCityMarketID) FROM mytable WHERE CRSDepTime < 955 OR DivWheelsOns <= 1911 OR OriginCityMarketID < 32575 LIMIT 1","hsqls":["SELECT COUNT(DepDel15), MIN(DepDelay), SUM(OriginCityMarketID) FROM mytable WHERE CRSDepTime < 955 OR (DivWheelsOns__MV0 <= 1911 OR DivWheelsOns__MV1 <= 1911 OR DivWheelsOns__MV2 <= 1911 OR DivWheelsOns__MV3 <= 1911 OR DivWheelsOns__MV4 <= 1911) OR OriginCityMarketID < 32575 LIMIT 10000"]}
+{"sql":"SELECT COUNT(DepDelay) FROM mytable WHERE DivArrDelay BETWEEN 81 AND 83 AND DivTailNums = 'N316JB' OR DivTailNums IN ('N934SW') LIMIT 7","hsqls":["SELECT COUNT(DepDelay) FROM mytable WHERE DivArrDelay BETWEEN 81 AND 83 AND (DivTailNums__MV0 = 'N316JB' OR DivTailNums__MV1 = 'N316JB' OR DivTailNums__MV2 = 'N316JB' OR DivTailNums__MV3 = 'N316JB' OR DivTailNums__MV4 = 'N316JB') OR (DivTailNums__MV0 IN ('N934SW') OR DivTailNums__MV1 IN ('N934SW') OR DivTailNums__MV2 IN ('N934SW') OR D [...]
+{"sql":"SELECT COUNT(DepTime) FROM mytable WHERE DivTailNums IN ('N3CYAA', 'N675AW') OR \"Month\" NOT IN (1) OR DivAirportIDs BETWEEN 14869 AND -9999 LIMIT 26","hsqls":["SELECT COUNT(DepTime) FROM mytable WHERE (DivTailNums__MV0 IN ('N3CYAA', 'N675AW') OR DivTailNums__MV1 IN ('N3CYAA', 'N675AW') OR DivTailNums__MV2 IN ('N3CYAA', 'N675AW') OR DivTailNums__MV3 IN ('N3CYAA', 'N675AW') OR DivTailNums__MV4 IN ('N3CYAA', 'N675AW')) OR Month NOT IN (1) OR (DivAirportIDs__MV0 BETWEEN 14869 AND - [...]
+{"sql":"SELECT COUNT(DestAirportSeqID) FROM mytable WHERE DivWheelsOns <= 1642 OR DivAirports BETWEEN 'SGU' AND 'ATW' OR OriginWac IN (54) LIMIT 13","hsqls":["SELECT COUNT(DestAirportSeqID) FROM mytable WHERE (DivWheelsOns__MV0 <= 1642 OR DivWheelsOns__MV1 <= 1642 OR DivWheelsOns__MV2 <= 1642 OR DivWheelsOns__MV3 <= 1642 OR DivWheelsOns__MV4 <= 1642) OR (DivAirports__MV0 BETWEEN 'SGU' AND 'ATW' OR DivAirports__MV1 BETWEEN 'SGU' AND 'ATW' OR DivAirports__MV2 BETWEEN 'SGU' AND 'ATW' OR Div [...]
+{"sql":"SELECT COUNT(DestAirportSeqID), SUM(WeatherDelay), AVG(DepTime) FROM mytable WHERE DivReachedDest BETWEEN 0 AND 0 AND DivLongestGTimes BETWEEN 34.0 AND 51.0 OR WeatherDelay BETWEEN 6 AND 72 LIMIT 23","hsqls":["SELECT COUNT(DestAirportSeqID), SUM(WeatherDelay), AVG(DepTime) FROM mytable WHERE DivReachedDest BETWEEN 0 AND 0 AND (DivLongestGTimes__MV0 BETWEEN 34.0 AND 51.0 OR DivLongestGTimes__MV1 BETWEEN 34.0 AND 51.0 OR DivLongestGTimes__MV2 BETWEEN 34.0 AND 51.0 OR DivLongestGTi [...]
+{"sql":"SELECT COUNT(DestState) FROM mytable WHERE DivAirportIDs IN (10158) AND OriginCityName NOT IN ('Brainerd, MN', 'Medford, OR') LIMIT 16","hsqls":["SELECT COUNT(DestState) FROM mytable WHERE (DivAirportIDs__MV0 IN (10158) OR DivAirportIDs__MV1 IN (10158) OR DivAirportIDs__MV2 IN (10158) OR DivAirportIDs__MV3 IN (10158) OR DivAirportIDs__MV4 IN (10158)) AND OriginCityName NOT IN ('Brainerd, MN', 'Medford, OR') LIMIT 10000"]}
+{"sql":"SELECT COUNT(DestStateName), SUM(ArrDelay), SUM(DepartureDelayGroups) FROM mytable WHERE DivAirportSeqIDs < 1234302 LIMIT 26","hsqls":["SELECT COUNT(DestStateName), SUM(ArrDelay), SUM(DepartureDelayGroups) FROM mytable WHERE (DivAirportSeqIDs__MV0 < 1234302 OR DivAirportSeqIDs__MV1 < 1234302 OR DivAirportSeqIDs__MV2 < 1234302 OR DivAirportSeqIDs__MV3 < 1234302 OR DivAirportSeqIDs__MV4 < 1234302) LIMIT 10000"]}
+{"sql":"SELECT COUNT(DestWac), AVG(Diverted), SUM(\"Year\") FROM mytable WHERE OriginWac NOT IN (45, 51, 37) OR ArrDelay BETWEEN 109.0 AND 211.0 AND TailNum > 'N3HHAA' LIMIT 3","hsqls":["SELECT COUNT(DestWac), AVG(Diverted), SUM(Year) FROM mytable WHERE OriginWac NOT IN (45, 51, 37) OR ArrDelay BETWEEN 109.0 AND 211.0 AND TailNum > 'N3HHAA' LIMIT 3"]}
+{"sql":"SELECT COUNT(DistanceGroup) FROM mytable WHERE DivTailNums BETWEEN 'N541AA' AND 'N14174' OR \"Month\" = 1 AND TaxiOut BETWEEN -9999 AND 34 LIMIT 7","hsqls":["SELECT COUNT(DistanceGroup) FROM mytable WHERE (DivTailNums__MV0 BETWEEN 'N541AA' AND 'N14174' OR DivTailNums__MV1 BETWEEN 'N541AA' AND 'N14174' OR DivTailNums__MV2 BETWEEN 'N541AA' AND 'N14174' OR DivTailNums__MV3 BETWEEN 'N541AA' AND 'N14174' OR DivTailNums__MV4 BETWEEN 'N541AA' AND 'N14174') OR Month = 1 AND TaxiOut BETWE [...]
+{"sql":"SELECT COUNT(DivActualElapsedTime), COUNT(OriginCityName) FROM mytable WHERE DestStateFips IN (35) AND ArrDelay BETWEEN 180.0 AND 66.0 OR DivWheelsOffs IN (1842, 1022, 1318) LIMIT 8","hsqls":["SELECT COUNT(DivActualElapsedTime), COUNT(OriginCityName) FROM mytable WHERE DestStateFips IN (35) AND ArrDelay BETWEEN 180.0 AND 66.0 OR (DivWheelsOffs__MV0 IN (1842, 1022, 1318) OR DivWheelsOffs__MV1 IN (1842, 1022, 1318) OR DivWheelsOffs__MV2 IN (1842, 1022, 1318) OR DivWheelsOffs__MV3 [...]
+{"sql":"SELECT COUNT(FirstDepTime) FROM mytable WHERE ArrTimeBlk = '1400-1459' OR DivAirports < 'GTF' AND TaxiIn NOT IN (96, 23, 13) LIMIT 21","hsqls":["SELECT COUNT(FirstDepTime) FROM mytable WHERE ArrTimeBlk = '1400-1459' OR (DivAirports__MV0 < 'GTF' OR DivAirports__MV1 < 'GTF' OR DivAirports__MV2 < 'GTF' OR DivAirports__MV3 < 'GTF' OR DivAirports__MV4 < 'GTF') AND TaxiIn NOT IN (96, 23, 13) LIMIT 10000"]}
+{"sql":"SELECT COUNT(Flights), AVG(ArrDel15), AVG(AirlineID) FROM mytable WHERE DivLongestGTimes IN (55.0) LIMIT 12","hsqls":["SELECT COUNT(Flights), AVG(ArrDel15), AVG(AirlineID) FROM mytable WHERE (DivLongestGTimes__MV0 IN (55.0) OR DivLongestGTimes__MV1 IN (55.0) OR DivLongestGTimes__MV2 IN (55.0) OR DivLongestGTimes__MV3 IN (55.0) OR DivLongestGTimes__MV4 IN (55.0)) LIMIT 10000"]}
+{"sql":"SELECT COUNT(Flights), MAX(Diverted), MIN(OriginCityMarketID) FROM mytable WHERE DestCityMarketID BETWEEN 33792 AND 32335 AND Dest IN ('SAF') OR DepTimeBlk IN ('1600-1659', '1700-1759', '2200-2259', '1400-1459') LIMIT 10"}
+{"sql":"SELECT COUNT(LongestAddGTime), SUM(OriginCityMarketID) FROM mytable WHERE \"Month\" BETWEEN 1 AND 1 OR CRSArrTime NOT IN (1723) LIMIT 18","hsqls":["SELECT COUNT(LongestAddGTime), SUM(OriginCityMarketID) FROM mytable WHERE Month BETWEEN 1 AND 1 OR CRSArrTime NOT IN (1723) LIMIT 18"]}
+{"sql":"SELECT COUNT(NASDelay), MAX(CarrierDelay), COUNT(DepTime) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR DivLongestGTimes BETWEEN 3.0 AND 40.0 LIMIT 9","hsqls":["SELECT COUNT(NASDelay), MAX(CarrierDelay), COUNT(DepTime) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR (DivLongestGTimes__MV0 BETWEEN 3.0 AND 40.0 OR DivLongestGTimes__MV1 BETWEEN 3.0 AND 40.0 OR DivLongestGTimes__MV2 BETWEEN 3.0 AND 40.0 OR DivLongestGTimes__MV3 BETWEEN 3.0 AND 40.0 OR DivLongestGTimes__MV4 BETWEEN 3.0 [...]
+{"sql":"SELECT COUNT(Origin), COUNT(\"Year\"), MIN(Flights) FROM mytable WHERE DivTotalGTimes BETWEEN 77 AND 73 AND DivTotalGTimes BETWEEN 66 AND 112 OR CRSDepTime NOT IN (1908, 1425, 1834) LIMIT 12","hsqls":["SELECT COUNT(Origin), COUNT(Year), MIN(Flights) FROM mytable WHERE (DivTotalGTimes__MV0 BETWEEN 77 AND 73 OR DivTotalGTimes__MV1 BETWEEN 77 AND 73 OR DivTotalGTimes__MV2 BETWEEN 77 AND 73 OR DivTotalGTimes__MV3 BETWEEN 77 AND 73 OR DivTotalGTimes__MV4 BETWEEN 77 AND 73) AND (DivTo [...]
+{"sql":"SELECT COUNT(OriginAirportID), MIN(OriginWac), MAX(OriginWac) FROM mytable WHERE \"Month\" IN (1) AND DestAirportID BETWEEN 11203 AND 13127 LIMIT 11","hsqls":["SELECT COUNT(OriginAirportID), MIN(OriginWac), MAX(OriginWac) FROM mytable WHERE Month IN (1) AND DestAirportID BETWEEN 11203 AND 13127 LIMIT 11"]}
+{"sql":"SELECT COUNT(OriginCityMarketID) FROM mytable WHERE DivWheelsOns <= 324 AND LongestAddGTime >= 30 AND \"Year\" NOT IN (2014) LIMIT 4","hsqls":["SELECT COUNT(OriginCityMarketID) FROM mytable WHERE (DivWheelsOns__MV0 <= 324 OR DivWheelsOns__MV1 <= 324 OR DivWheelsOns__MV2 <= 324 OR DivWheelsOns__MV3 <= 324 OR DivWheelsOns__MV4 <= 324) AND LongestAddGTime >= 30 AND Year NOT IN (2014) LIMIT 10000"]}
+{"sql":"SELECT COUNT(OriginCityMarketID), MAX(DestCityMarketID) FROM mytable WHERE Quarter NOT IN (1) OR Distance BETWEEN 1454 AND 196 AND DivAirportIDs <= 14006 LIMIT 22","hsqls":["SELECT COUNT(OriginCityMarketID), MAX(DestCityMarketID) FROM mytable WHERE Quarter NOT IN (1) OR Distance BETWEEN 1454 AND 196 AND (DivAirportIDs__MV0 <= 14006 OR DivAirportIDs__MV1 <= 14006 OR DivAirportIDs__MV2 <= 14006 OR DivAirportIDs__MV3 <= 14006 OR DivAirportIDs__MV4 <= 14006) LIMIT 10000"]}
+{"sql":"SELECT COUNT(OriginWac) FROM mytable WHERE CancellationCode BETWEEN 'A' AND 'A' AND DivTailNums BETWEEN 'N397DA' AND 'N940DN' LIMIT 5","hsqls":["SELECT COUNT(OriginWac) FROM mytable WHERE CancellationCode BETWEEN 'A' AND 'A' AND (DivTailNums__MV0 BETWEEN 'N397DA' AND 'N940DN' OR DivTailNums__MV1 BETWEEN 'N397DA' AND 'N940DN' OR DivTailNums__MV2 BETWEEN 'N397DA' AND 'N940DN' OR DivTailNums__MV3 BETWEEN 'N397DA' AND 'N940DN' OR DivTailNums__MV4 BETWEEN 'N397DA' AND 'N940DN') LIMIT [...]
+{"sql":"SELECT COUNT(Quarter), COUNT(ArrivalDelayGroups), AVG(FlightNum) FROM mytable WHERE DivTotalGTimes BETWEEN 25 AND 116 LIMIT 19","hsqls":["SELECT COUNT(Quarter), COUNT(ArrivalDelayGroups), AVG(FlightNum) FROM mytable WHERE (DivTotalGTimes__MV0 BETWEEN 25 AND 116 OR DivTotalGTimes__MV1 BETWEEN 25 AND 116 OR DivTotalGTimes__MV2 BETWEEN 25 AND 116 OR DivTotalGTimes__MV3 BETWEEN 25 AND 116 OR DivTotalGTimes__MV4 BETWEEN 25 AND 116) LIMIT 10000"]}
+{"sql":"SELECT COUNT(\"Month\") FROM mytable WHERE DivAirports >= 'CID' AND TaxiIn = 116 OR DestState <= 'MS' LIMIT 25","hsqls":["SELECT COUNT(Month) FROM mytable WHERE (DivAirports__MV0 >= 'CID' OR DivAirports__MV1 >= 'CID' OR DivAirports__MV2 >= 'CID' OR DivAirports__MV3 >= 'CID' OR DivAirports__MV4 >= 'CID') AND TaxiIn = 116 OR DestState <= 'MS' LIMIT 10000"]}
+{"sql":"SELECT COUNT(\"Month\"), MIN(DepDel15) FROM mytable WHERE DivAirports IN ('CPR', 'SGU', 'SPS', 'PHX') LIMIT 13","hsqls":["SELECT COUNT(Month), MIN(DepDel15) FROM mytable WHERE (DivAirports__MV0 IN ('CPR', 'SGU', 'SPS', 'PHX') OR DivAirports__MV1 IN ('CPR', 'SGU', 'SPS', 'PHX') OR DivAirports__MV2 IN ('CPR', 'SGU', 'SPS', 'PHX') OR DivAirports__MV3 IN ('CPR', 'SGU', 'SPS', 'PHX') OR DivAirports__MV4 IN ('CPR', 'SGU', 'SPS', 'PHX')) LIMIT 10000"]}
+{"sql":"SELECT COUNT(\"Month\"), MIN(DivReachedDest) FROM mytable WHERE DivArrDelay BETWEEN 258 AND 1153 AND DestState NOT IN ('MO') LIMIT 14","hsqls":["SELECT COUNT(Month), MIN(DivReachedDest) FROM mytable WHERE DivArrDelay BETWEEN 258 AND 1153 AND DestState NOT IN ('MO') LIMIT 14"]}
+{"sql":"SELECT COUNT(\"Month\"), SUM(OriginAirportSeqID), MIN(AirlineID) FROM mytable WHERE DivTailNums <= 'N530MQ' AND AirTime NOT IN (122, 158, 73, 142) OR DestAirportID NOT IN (10423, 13303, 10581, 10747) LIMIT 2","hsqls":["SELECT COUNT(Month), SUM(OriginAirportSeqID), MIN(AirlineID) FROM mytable WHERE (DivTailNums__MV0 <= 'N530MQ' OR DivTailNums__MV1 <= 'N530MQ' OR DivTailNums__MV2 <= 'N530MQ' OR DivTailNums__MV3 <= 'N530MQ' OR DivTailNums__MV4 <= 'N530MQ') AND AirTime NOT IN (122, [...]
+{"sql":"SELECT MAX(AirTime) FROM mytable WHERE DaysSinceEpoch <> 16071 OR DivTailNums IN ('N713SK') AND DivActualElapsedTime BETWEEN 153 AND 1043 LIMIT 10","hsqls":["SELECT MAX(AirTime) FROM mytable WHERE DaysSinceEpoch <> 16071 OR (DivTailNums__MV0 IN ('N713SK') OR DivTailNums__MV1 IN ('N713SK') OR DivTailNums__MV2 IN ('N713SK') OR DivTailNums__MV3 IN ('N713SK') OR DivTailNums__MV4 IN ('N713SK')) AND DivActualElapsedTime BETWEEN 153 AND 1043 LIMIT 10000"]}
+{"sql":"SELECT MAX(AirlineID), MIN(OriginAirportSeqID), SUM(ArrivalDelayGroups) FROM mytable WHERE \"Year\" = 2014 AND DestStateFips IN (15) LIMIT 6","hsqls":["SELECT MAX(AirlineID), MIN(OriginAirportSeqID), SUM(ArrivalDelayGroups) FROM mytable WHERE Year = 2014 AND DestStateFips IN (15) LIMIT 6"]}
+{"sql":"SELECT MAX(ArrDelay), AVG(\"Month\"), MAX(ActualElapsedTime) FROM mytable WHERE DepTimeBlk IN ('2000-2059', '1300-1359', '1100-1159', '0600-0659', '0800-0859') LIMIT 14","hsqls":["SELECT MAX(ArrDelay), AVG(Month), MAX(ActualElapsedTime) FROM mytable WHERE DepTimeBlk IN ('2000-2059', '1300-1359', '1100-1159', '0600-0659', '0800-0859') LIMIT 14"]}
+{"sql":"SELECT MAX(ArrivalDelayGroups), AVG(DepartureDelayGroups) FROM mytable WHERE DivWheelsOns IN (1750, 910, 1624) OR DayofMonth BETWEEN 9 AND 31 LIMIT 11","hsqls":["SELECT MAX(ArrivalDelayGroups), AVG(DepartureDelayGroups) FROM mytable WHERE (DivWheelsOns__MV0 IN (1750, 910, 1624) OR DivWheelsOns__MV1 IN (1750, 910, 1624) OR DivWheelsOns__MV2 IN (1750, 910, 1624) OR DivWheelsOns__MV3 IN (1750, 910, 1624) OR DivWheelsOns__MV4 IN (1750, 910, 1624)) OR DayofMonth BETWEEN 9 AND 31 LIMI [...]
+{"sql":"SELECT MAX(ArrivalDelayGroups), MIN(NASDelay) FROM mytable WHERE Carrier BETWEEN 'AA' AND 'OO' AND DivTotalGTimes > 25 LIMIT 16","hsqls":["SELECT MAX(ArrivalDelayGroups), MIN(NASDelay) FROM mytable WHERE Carrier BETWEEN 'AA' AND 'OO' AND (DivTotalGTimes__MV0 > 25 OR DivTotalGTimes__MV1 > 25 OR DivTotalGTimes__MV2 > 25 OR DivTotalGTimes__MV3 > 25 OR DivTotalGTimes__MV4 > 25) LIMIT 10000"]}
+{"sql":"SELECT MAX(CarrierDelay), AVG(DayofMonth), MAX(DestCityMarketID) FROM mytable WHERE DivTailNums BETWEEN 'N248WN' AND 'N493AA' OR DepDelay >= -8.0 OR WheelsOn IN (959, 1042, 2105) LIMIT 27","hsqls":["SELECT MAX(CarrierDelay), AVG(DayofMonth), MAX(DestCityMarketID) FROM mytable WHERE (DivTailNums__MV0 BETWEEN 'N248WN' AND 'N493AA' OR DivTailNums__MV1 BETWEEN 'N248WN' AND 'N493AA' OR DivTailNums__MV2 BETWEEN 'N248WN' AND 'N493AA' OR DivTailNums__MV3 BETWEEN 'N248WN' AND 'N493AA' OR [...]
+{"sql":"SELECT MAX(DayOfWeek) FROM mytable WHERE AirTime BETWEEN 349 AND 225 OR DivWheelsOffs IN (1756, 2130, 1453) OR OriginStateFips BETWEEN 34 AND 16 LIMIT 10","hsqls":["SELECT MAX(DayOfWeek) FROM mytable WHERE AirTime BETWEEN 349 AND 225 OR (DivWheelsOffs__MV0 IN (1756, 2130, 1453) OR DivWheelsOffs__MV1 IN (1756, 2130, 1453) OR DivWheelsOffs__MV2 IN (1756, 2130, 1453) OR DivWheelsOffs__MV3 IN (1756, 2130, 1453) OR DivWheelsOffs__MV4 IN (1756, 2130, 1453)) OR OriginStateFips BETWEEN 3 [...]
+{"sql":"SELECT MAX(DepDel15) FROM mytable WHERE DivTailNums IN ('N922MQ', 'N980SW') OR Cancelled NOT IN (1, 0) LIMIT 21","hsqls":["SELECT MAX(DepDel15) FROM mytable WHERE (DivTailNums__MV0 IN ('N922MQ', 'N980SW') OR DivTailNums__MV1 IN ('N922MQ', 'N980SW') OR DivTailNums__MV2 IN ('N922MQ', 'N980SW') OR DivTailNums__MV3 IN ('N922MQ', 'N980SW') OR DivTailNums__MV4 IN ('N922MQ', 'N980SW')) OR Cancelled NOT IN (1, 0) LIMIT 10000"]}
+{"sql":"SELECT MAX(DepTime), SUM(\"Month\"), MIN(WheelsOff) FROM mytable WHERE DepTime IN (1005, 1811, 1016, 1354, 2023) AND ArrivalDelayGroups = -1 OR TailNum IN ('N597AA', 'N14125', 'N902FR', 'N280WN') LIMIT 17","hsqls":["SELECT MAX(DepTime), SUM(Month), MIN(WheelsOff) FROM mytable WHERE DepTime IN (1005, 1811, 1016, 1354, 2023) AND ArrivalDelayGroups = -1 OR TailNum IN ('N597AA', 'N14125', 'N902FR', 'N280WN') LIMIT 17"]}
+{"sql":"SELECT MAX(DestStateFips) FROM mytable WHERE DivAirportIDs IN (15919, 14783, 11252, 14288, 11638) LIMIT 9","hsqls":["SELECT MAX(DestStateFips) FROM mytable WHERE (DivAirportIDs__MV0 IN (15919, 14783, 11252, 14288, 11638) OR DivAirportIDs__MV1 IN (15919, 14783, 11252, 14288, 11638) OR DivAirportIDs__MV2 IN (15919, 14783, 11252, 14288, 11638) OR DivAirportIDs__MV3 IN (15919, 14783, 11252, 14288, 11638) OR DivAirportIDs__MV4 IN (15919, 14783, 11252, 14288, 11638)) LIMIT 10000"]}
+{"sql":"SELECT MAX(DestStateFips), AVG(LongestAddGTime), AVG(DepDelay) FROM mytable WHERE DivTailNums > 'N687SW' LIMIT 11","hsqls":["SELECT MAX(DestStateFips), AVG(LongestAddGTime), AVG(DepDelay) FROM mytable WHERE (DivTailNums__MV0 > 'N687SW' OR DivTailNums__MV1 > 'N687SW' OR DivTailNums__MV2 > 'N687SW' OR DivTailNums__MV3 > 'N687SW' OR DivTailNums__MV4 > 'N687SW') LIMIT 10000"]}
+{"sql":"SELECT MAX(DistanceGroup), AVG(SecurityDelay), SUM(DestWac) FROM mytable WHERE NASDelay IN (49, 145, 45) AND DivWheelsOffs < 917 AND UniqueCarrier NOT IN ('F9', 'WN', 'OO', 'MQ', 'VX') LIMIT 27","hsqls":["SELECT MAX(DistanceGroup), AVG(SecurityDelay), SUM(DestWac) FROM mytable WHERE NASDelay IN (49, 145, 45) AND (DivWheelsOffs__MV0 < 917 OR DivWheelsOffs__MV1 < 917 OR DivWheelsOffs__MV2 < 917 OR DivWheelsOffs__MV3 < 917 OR DivWheelsOffs__MV4 < 917) AND UniqueCarrier NOT IN ('F9' [...]
+{"sql":"SELECT MAX(DivActualElapsedTime), MIN(\"Month\"), AVG(WheelsOff) FROM mytable WHERE Diverted NOT IN (1, 0) OR Diverted BETWEEN 0 AND 1 AND DestCityMarketID = 31136 LIMIT 27","hsqls":["SELECT MAX(DivActualElapsedTime), MIN(Month), AVG(WheelsOff) FROM mytable WHERE Diverted NOT IN (1, 0) OR Diverted BETWEEN 0 AND 1 AND DestCityMarketID = 31136 LIMIT 27"]}
+{"sql":"SELECT MAX(LongestAddGTime) FROM mytable WHERE DestStateName NOT IN ('New Hampshire', 'Massachusetts', 'California', 'Nevada') OR DaysSinceEpoch IN (16071, 16088, 16074, 16078, 16091) OR DivWheelsOns = 1317 LIMIT 11","hsqls":["SELECT MAX(LongestAddGTime) FROM mytable WHERE DestStateName NOT IN ('New Hampshire', 'Massachusetts', 'California', 'Nevada') OR DaysSinceEpoch IN (16071, 16088, 16074, 16078, 16091) OR (DivWheelsOns__MV0 = 1317 OR DivWheelsOns__MV1 = 1317 OR DivWheelsOns_ [...]
+{"sql":"SELECT MAX(LongestAddGTime) FROM mytable WHERE WheelsOn NOT IN (1659, 936) OR DivTotalGTimes > 76 LIMIT 1","hsqls":["SELECT MAX(LongestAddGTime) FROM mytable WHERE WheelsOn NOT IN (1659, 936) OR (DivTotalGTimes__MV0 > 76 OR DivTotalGTimes__MV1 > 76 OR DivTotalGTimes__MV2 > 76 OR DivTotalGTimes__MV3 > 76 OR DivTotalGTimes__MV4 > 76) LIMIT 10000"]}
+{"sql":"SELECT MAX(OriginAirportSeqID), AVG(DepartureDelayGroups) FROM mytable WHERE DivLongestGTimes IN (74.0) OR TaxiOut BETWEEN 87 AND 30 AND WeatherDelay IN (1) LIMIT 8","hsqls":["SELECT MAX(OriginAirportSeqID), AVG(DepartureDelayGroups) FROM mytable WHERE (DivLongestGTimes__MV0 IN (74.0) OR DivLongestGTimes__MV1 IN (74.0) OR DivLongestGTimes__MV2 IN (74.0) OR DivLongestGTimes__MV3 IN (74.0) OR DivLongestGTimes__MV4 IN (74.0)) OR TaxiOut BETWEEN 87 AND 30 AND WeatherDelay IN (1) LIM [...]
+{"sql":"SELECT MAX(TotalAddGTime), SUM(DayofMonth), MIN(\"Month\") FROM mytable WHERE DivAirportIDs BETWEEN 10721 AND 11953 OR SecurityDelay BETWEEN 18 AND -9999 AND ArrTime > 1548 LIMIT 9","hsqls":["SELECT MAX(TotalAddGTime), SUM(DayofMonth), MIN(Month) FROM mytable WHERE (DivAirportIDs__MV0 BETWEEN 10721 AND 11953 OR DivAirportIDs__MV1 BETWEEN 10721 AND 11953 OR DivAirportIDs__MV2 BETWEEN 10721 AND 11953 OR DivAirportIDs__MV3 BETWEEN 10721 AND 11953 OR DivAirportIDs__MV4 BETWEEN 10721 [...]
+{"sql":"SELECT MAX(TotalAddGTime), SUM(WeatherDelay) FROM mytable WHERE \"Month\" <> 1 OR Distance >= 3904 OR DivActualElapsedTime BETWEEN 252 AND 552 LIMIT 21","hsqls":["SELECT MAX(TotalAddGTime), SUM(WeatherDelay) FROM mytable WHERE Month <> 1 OR Distance >= 3904 OR DivActualElapsedTime BETWEEN 252 AND 552 LIMIT 21"]}
+{"sql":"SELECT MAX(WheelsOff), AVG(ArrivalDelayGroups), MAX(CRSElapsedTime) FROM mytable WHERE LongestAddGTime BETWEEN 40 AND 148 AND DivLongestGTimes BETWEEN 36.0 AND 97.0 LIMIT 10","hsqls":["SELECT MAX(WheelsOff), AVG(ArrivalDelayGroups), MAX(CRSElapsedTime) FROM mytable WHERE LongestAddGTime BETWEEN 40 AND 148 AND (DivLongestGTimes__MV0 BETWEEN 36.0 AND 97.0 OR DivLongestGTimes__MV1 BETWEEN 36.0 AND 97.0 OR DivLongestGTimes__MV2 BETWEEN 36.0 AND 97.0 OR DivLongestGTimes__MV3 BETWEEN [...]
+{"sql":"SELECT MAX(WheelsOff), COUNT(CancellationCode) FROM mytable WHERE ArrDel15 IN (1, 0, -9999) OR DivLongestGTimes < 57.0 OR DepDelay NOT IN (342.0, 48.0) LIMIT 25","hsqls":["SELECT MAX(WheelsOff), COUNT(CancellationCode) FROM mytable WHERE ArrDel15 IN (1, 0, -9999) OR (DivLongestGTimes__MV0 < 57.0 OR DivLongestGTimes__MV1 < 57.0 OR DivLongestGTimes__MV2 < 57.0 OR DivLongestGTimes__MV3 < 57.0 OR DivLongestGTimes__MV4 < 57.0) OR DepDelay NOT IN (342.0, 48.0) LIMIT 10000"]}
+{"sql":"SELECT MAX(\"Month\") FROM mytable WHERE CRSDepTime IN (1534, 2213) OR DestCityName BETWEEN 'Sacramento, CA' AND 'Nome, AK' OR ArrDelay > -7.0 LIMIT 11","hsqls":["SELECT MAX(Month) FROM mytable WHERE CRSDepTime IN (1534, 2213) OR DestCityName BETWEEN 'Sacramento, CA' AND 'Nome, AK' OR ArrDelay > -7.0 LIMIT 11"]}
+{"sql":"SELECT MAX(\"Year\") FROM mytable WHERE DivWheelsOns >= 2058 OR UniqueCarrier BETWEEN 'VX' AND 'US' OR CRSElapsedTime > 290 LIMIT 20","hsqls":["SELECT MAX(Year) FROM mytable WHERE (DivWheelsOns__MV0 >= 2058 OR DivWheelsOns__MV1 >= 2058 OR DivWheelsOns__MV2 >= 2058 OR DivWheelsOns__MV3 >= 2058 OR DivWheelsOns__MV4 >= 2058) OR UniqueCarrier BETWEEN 'VX' AND 'US' OR CRSElapsedTime > 290 LIMIT 10000"]}
+{"sql":"SELECT MAX(\"Year\"), COUNT(DistanceGroup) FROM mytable WHERE OriginCityName BETWEEN 'Knoxville, TN' AND 'Medford, OR' OR Carrier NOT IN ('EV', 'DL', 'FL', 'AS') AND OriginAirportSeqID BETWEEN 1410002 AND 1584102 LIMIT 26","hsqls":["SELECT MAX(Year), COUNT(DistanceGroup) FROM mytable WHERE OriginCityName BETWEEN 'Knoxville, TN' AND 'Medford, OR' OR Carrier NOT IN ('EV', 'DL', 'FL', 'AS') AND OriginAirportSeqID BETWEEN 1410002 AND 1584102 LIMIT 26"]}
+{"sql":"SELECT MAX(\"Year\"), MIN(DepartureDelayGroups), COUNT(CancellationCode) FROM mytable WHERE ArrivalDelayGroups IN (10, 0, -2, 9, 11) LIMIT 8","hsqls":["SELECT MAX(Year), MIN(DepartureDelayGroups), COUNT(CancellationCode) FROM mytable WHERE ArrivalDelayGroups IN (10, 0, -2, 9, 11) LIMIT 8"]}
+{"sql":"SELECT MIN(AirTime), SUM(ActualElapsedTime), MAX(LateAircraftDelay) FROM mytable WHERE DivAirports IN ('DAB', 'HOU') AND WheelsOff <= 1502 OR OriginWac >= 21 LIMIT 24","hsqls":["SELECT MIN(AirTime), SUM(ActualElapsedTime), MAX(LateAircraftDelay) FROM mytable WHERE (DivAirports__MV0 IN ('DAB', 'HOU') OR DivAirports__MV1 IN ('DAB', 'HOU') OR DivAirports__MV2 IN ('DAB', 'HOU') OR DivAirports__MV3 IN ('DAB', 'HOU') OR DivAirports__MV4 IN ('DAB', 'HOU')) AND WheelsOff <= 1502 OR Orig [...]
+{"sql":"SELECT MIN(AirTime), SUM(DepDel15), SUM(DestStateFips) FROM mytable WHERE DivTailNums IN ('N873AS')","hsqls":["SELECT MIN(AirTime), SUM(DepDel15), SUM(DestStateFips) FROM mytable WHERE (DivTailNums__MV0 IN ('N873AS') OR DivTailNums__MV1 IN ('N873AS') OR DivTailNums__MV2 IN ('N873AS') OR DivTailNums__MV3 IN ('N873AS') OR DivTailNums__MV4 IN ('N873AS')) LIMIT 10000"]}
+{"sql":"SELECT MIN(ArrDelay), COUNT(CRSDepTime), SUM(DayOfWeek) FROM mytable WHERE DivWheelsOffs >= 2009 AND Diverted >= 1 OR OriginCityMarketID >= 34783 LIMIT 29","hsqls":["SELECT MIN(ArrDelay), COUNT(CRSDepTime), SUM(DayOfWeek) FROM mytable WHERE (DivWheelsOffs__MV0 >= 2009 OR DivWheelsOffs__MV1 >= 2009 OR DivWheelsOffs__MV2 >= 2009 OR DivWheelsOffs__MV3 >= 2009 OR DivWheelsOffs__MV4 >= 2009) AND Diverted >= 1 OR OriginCityMarketID >= 34783 LIMIT 10000"]}
+{"sql":"SELECT MIN(ArrTime), AVG(AirlineID), COUNT(WeatherDelay) FROM mytable WHERE OriginCityName NOT IN ('Columbus, GA', 'Raleigh/Durham, NC') OR DivTailNums IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') LIMIT 29","hsqls":["SELECT MIN(ArrTime), AVG(AirlineID), COUNT(WeatherDelay) FROM mytable WHERE OriginCityName NOT IN ('Columbus, GA', 'Raleigh/Durham, NC') OR (DivTailNums__MV0 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR DivTailNums__MV1 IN ('N314US', 'N3751B', ' [...]
+{"sql":"SELECT MIN(DaysSinceEpoch), AVG(FlightNum) FROM mytable WHERE DepDel15 IN (1, 0, -9999) AND AirlineID BETWEEN 20366 AND 19393 OR DivAirportIDs IN (14730, 14262, 10868) LIMIT 6","hsqls":["SELECT MIN(DaysSinceEpoch), AVG(FlightNum) FROM mytable WHERE DepDel15 IN (1, 0, -9999) AND AirlineID BETWEEN 20366 AND 19393 OR (DivAirportIDs__MV0 IN (14730, 14262, 10868) OR DivAirportIDs__MV1 IN (14730, 14262, 10868) OR DivAirportIDs__MV2 IN (14730, 14262, 10868) OR DivAirportIDs__MV3 IN (14 [...]
+{"sql":"SELECT MIN(DaysSinceEpoch), COUNT(CRSElapsedTime) FROM mytable WHERE UniqueCarrier IN ('EV', 'F9', 'MQ', 'UA') AND DivWheelsOns IN (1717, 102, 1835) LIMIT 24","hsqls":["SELECT MIN(DaysSinceEpoch), COUNT(CRSElapsedTime) FROM mytable WHERE UniqueCarrier IN ('EV', 'F9', 'MQ', 'UA') AND (DivWheelsOns__MV0 IN (1717, 102, 1835) OR DivWheelsOns__MV1 IN (1717, 102, 1835) OR DivWheelsOns__MV2 IN (1717, 102, 1835) OR DivWheelsOns__MV3 IN (1717, 102, 1835) OR DivWheelsOns__MV4 IN (1717, 10 [...]
+{"sql":"SELECT MIN(DepDelay) FROM mytable WHERE DivAirportIDs IN (15323, 10627) LIMIT 18","hsqls":["SELECT MIN(DepDelay) FROM mytable WHERE (DivAirportIDs__MV0 IN (15323, 10627) OR DivAirportIDs__MV1 IN (15323, 10627) OR DivAirportIDs__MV2 IN (15323, 10627) OR DivAirportIDs__MV3 IN (15323, 10627) OR DivAirportIDs__MV4 IN (15323, 10627)) LIMIT 10000"]}
+{"sql":"SELECT MIN(DepDelayMinutes), COUNT(\"Year\") FROM mytable WHERE AirlineID BETWEEN 19930 AND 20355 LIMIT 1","hsqls":["SELECT MIN(DepDelayMinutes), COUNT(Year) FROM mytable WHERE AirlineID BETWEEN 19930 AND 20355 LIMIT 1"]}
+{"sql":"SELECT MIN(DepDelayMinutes), MAX(LongestAddGTime), SUM(TaxiIn) FROM mytable WHERE DivTotalGTimes > 3 AND CancellationCode BETWEEN 'noodles' AND 'A' OR DivWheelsOffs > 1614 LIMIT 24","hsqls":["SELECT MIN(DepDelayMinutes), MAX(LongestAddGTime), SUM(TaxiIn) FROM mytable WHERE (DivTotalGTimes__MV0 > 3 OR DivTotalGTimes__MV1 > 3 OR DivTotalGTimes__MV2 > 3 OR DivTotalGTimes__MV3 > 3 OR DivTotalGTimes__MV4 > 3) AND CancellationCode BETWEEN 'noodles' AND 'A' OR (DivWheelsOffs__MV0 > 161 [...]
+{"sql":"SELECT MIN(DepDelayMinutes), MIN(OriginCityMarketID) FROM mytable WHERE DivWheelsOffs BETWEEN 849 AND 1758 OR OriginCityMarketID NOT IN (33044) OR DivDistance = 861 LIMIT 26","hsqls":["SELECT MIN(DepDelayMinutes), MIN(OriginCityMarketID) FROM mytable WHERE (DivWheelsOffs__MV0 BETWEEN 849 AND 1758 OR DivWheelsOffs__MV1 BETWEEN 849 AND 1758 OR DivWheelsOffs__MV2 BETWEEN 849 AND 1758 OR DivWheelsOffs__MV3 BETWEEN 849 AND 1758 OR DivWheelsOffs__MV4 BETWEEN 849 AND 1758) OR OriginCit [...]
+{"sql":"SELECT MIN(DepartureDelayGroups) FROM mytable WHERE Cancelled BETWEEN 1 AND 1 AND \"Year\" > 2014 OR OriginCityMarketID > 30627 LIMIT 23","hsqls":["SELECT MIN(DepartureDelayGroups) FROM mytable WHERE Cancelled BETWEEN 1 AND 1 AND Year > 2014 OR OriginCityMarketID > 30627 LIMIT 23"]}
+{"sql":"SELECT MIN(DepartureDelayGroups) FROM mytable WHERE DivReachedDest IN (1) OR DivWheelsOffs IN (1523, 1157, 2046, 1219) OR DivAirportSeqIDs BETWEEN 1062002 AND 1233904 LIMIT 28","hsqls":["SELECT MIN(DepartureDelayGroups) FROM mytable WHERE DivReachedDest IN (1) OR (DivWheelsOffs__MV0 IN (1523, 1157, 2046, 1219) OR DivWheelsOffs__MV1 IN (1523, 1157, 2046, 1219) OR DivWheelsOffs__MV2 IN (1523, 1157, 2046, 1219) OR DivWheelsOffs__MV3 IN (1523, 1157, 2046, 1219) OR DivWheelsOffs__MV4 [...]
+{"sql":"SELECT MIN(DestWac), SUM(ArrivalDelayGroups), SUM(CRSArrTime) FROM mytable WHERE DivAirportIDs > 10713 LIMIT 20","hsqls":["SELECT MIN(DestWac), SUM(ArrivalDelayGroups), SUM(CRSArrTime) FROM mytable WHERE (DivAirportIDs__MV0 > 10713 OR DivAirportIDs__MV1 > 10713 OR DivAirportIDs__MV2 > 10713 OR DivAirportIDs__MV3 > 10713 OR DivAirportIDs__MV4 > 10713) LIMIT 10000"]}
+{"sql":"SELECT MIN(DivActualElapsedTime), AVG(AirlineID), AVG(OriginCityMarketID) FROM mytable WHERE \"Month\" BETWEEN 1 AND 1 OR OriginState IN ('WY', 'VT', 'OR', 'HI') AND DepartureDelayGroups BETWEEN 5 AND 9 LIMIT 2","hsqls":["SELECT MIN(DivActualElapsedTime), AVG(AirlineID), AVG(OriginCityMarketID) FROM mytable WHERE Month BETWEEN 1 AND 1 OR OriginState IN ('WY', 'VT', 'OR', 'HI') AND DepartureDelayGroups BETWEEN 5 AND 9 LIMIT 2"]}
+{"sql":"SELECT MIN(DivActualElapsedTime), MAX(DivAirportLandings) FROM mytable WHERE DivTotalGTimes IN (3, 4, 15, 99, 14) OR TotalAddGTime NOT IN (41, 40, 63, 14, 38) OR DivDistance IN (1590, 369, 490, 177, 191) LIMIT 7","hsqls":["SELECT MIN(DivActualElapsedTime), MAX(DivAirportLandings) FROM mytable WHERE (DivTotalGTimes__MV0 IN (3, 4, 15, 99, 14) OR DivTotalGTimes__MV1 IN (3, 4, 15, 99, 14) OR DivTotalGTimes__MV2 IN (3, 4, 15, 99, 14) OR DivTotalGTimes__MV3 IN (3, 4, 15, 99, 14) OR Di [...]
+{"sql":"SELECT MIN(DivActualElapsedTime), MAX(OriginAirportID) FROM mytable WHERE DivAirports IN ('BDL', 'OAK') LIMIT 25","hsqls":["SELECT MIN(DivActualElapsedTime), MAX(OriginAirportID) FROM mytable WHERE (DivAirports__MV0 IN ('BDL', 'OAK') OR DivAirports__MV1 IN ('BDL', 'OAK') OR DivAirports__MV2 IN ('BDL', 'OAK') OR DivAirports__MV3 IN ('BDL', 'OAK') OR DivAirports__MV4 IN ('BDL', 'OAK')) LIMIT 10000"]}
+{"sql":"SELECT MIN(DivActualElapsedTime), MIN(TotalAddGTime) FROM mytable WHERE \"Month\" = 1 OR DepTimeBlk <> '2000-2059' LIMIT 22","hsqls":["SELECT MIN(DivActualElapsedTime), MIN(TotalAddGTime) FROM mytable WHERE Month = 1 OR DepTimeBlk <> '2000-2059' LIMIT 22"]}
+{"sql":"SELECT MIN(DivDistance), MIN(CarrierDelay), SUM(DepDelay) FROM mytable WHERE DivTotalGTimes = 47 LIMIT 9","hsqls":["SELECT MIN(DivDistance), MIN(CarrierDelay), SUM(DepDelay) FROM mytable WHERE (DivTotalGTimes__MV0 = 47 OR DivTotalGTimes__MV1 = 47 OR DivTotalGTimes__MV2 = 47 OR DivTotalGTimes__MV3 = 47 OR DivTotalGTimes__MV4 = 47) LIMIT 10000"]}
+{"sql":"SELECT MIN(DivReachedDest), AVG(AirTime) FROM mytable WHERE DivReachedDest BETWEEN -9999 AND -9999 AND \"Year\" < 2014 OR CRSElapsedTime >= 337 LIMIT 29","hsqls":["SELECT MIN(DivReachedDest), AVG(AirTime) FROM mytable WHERE DivReachedDest BETWEEN -9999 AND -9999 AND Year < 2014 OR CRSElapsedTime >= 337 LIMIT 29"]}
+{"sql":"SELECT MIN(FlightNum), MAX(CRSDepTime), COUNT(DestState) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR \"Month\" <> 1 AND DivReachedDest BETWEEN 0 AND 0 LIMIT 5","hsqls":["SELECT MIN(FlightNum), MAX(CRSDepTime), COUNT(DestState) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR Month <> 1 AND DivReachedDest BETWEEN 0 AND 0 LIMIT 5"]}
+{"sql":"SELECT MIN(Flights), SUM(CRSArrTime) FROM mytable WHERE FlightNum NOT IN (4484) AND DivAirportSeqIDs >= 1323202 AND DayOfWeek NOT IN (2, 1) LIMIT 14","hsqls":["SELECT MIN(Flights), SUM(CRSArrTime) FROM mytable WHERE FlightNum NOT IN (4484) AND (DivAirportSeqIDs__MV0 >= 1323202 OR DivAirportSeqIDs__MV1 >= 1323202 OR DivAirportSeqIDs__MV2 >= 1323202 OR DivAirportSeqIDs__MV3 >= 1323202 OR DivAirportSeqIDs__MV4 >= 1323202) AND DayOfWeek NOT IN (2, 1) LIMIT 10000"]}
+{"sql":"SELECT MIN(NASDelay), MAX(DivReachedDest) FROM mytable WHERE DivAirportSeqIDs = 1474703 OR ActualElapsedTime BETWEEN 402 AND 535 OR DivWheelsOffs > 2338 LIMIT 3","hsqls":["SELECT MIN(NASDelay), MAX(DivReachedDest) FROM mytable WHERE (DivAirportSeqIDs__MV0 = 1474703 OR DivAirportSeqIDs__MV1 = 1474703 OR DivAirportSeqIDs__MV2 = 1474703 OR DivAirportSeqIDs__MV3 = 1474703 OR DivAirportSeqIDs__MV4 = 1474703) OR ActualElapsedTime BETWEEN 402 AND 535 OR (DivWheelsOffs__MV0 > 2338 OR Div [...]
+{"sql":"SELECT MIN(OriginAirportSeqID), COUNT(SecurityDelay), COUNT(TaxiOut) FROM mytable WHERE DepTimeBlk NOT IN ('0800-0859') OR DepTime < 111 AND \"Year\" < 2014 LIMIT 4","hsqls":["SELECT MIN(OriginAirportSeqID), COUNT(SecurityDelay), COUNT(TaxiOut) FROM mytable WHERE DepTimeBlk NOT IN ('0800-0859') OR DepTime < 111 AND Year < 2014 LIMIT 4"]}
+{"sql":"SELECT MIN(OriginStateFips), AVG(OriginAirportSeqID), SUM(AirTime) FROM mytable WHERE DivWheelsOns IN (2041, 2350, 1553, 1546) LIMIT 10","hsqls":["SELECT MIN(OriginStateFips), AVG(OriginAirportSeqID), SUM(AirTime) FROM mytable WHERE (DivWheelsOns__MV0 IN (2041, 2350, 1553, 1546) OR DivWheelsOns__MV1 IN (2041, 2350, 1553, 1546) OR DivWheelsOns__MV2 IN (2041, 2350, 1553, 1546) OR DivWheelsOns__MV3 IN (2041, 2350, 1553, 1546) OR DivWheelsOns__MV4 IN (2041, 2350, 1553, 1546)) LIMIT [...]
+{"sql":"SELECT MIN(OriginStateFips), MAX(FirstDepTime), AVG(DestAirportID) FROM mytable WHERE DivAirportSeqIDs IN (1327702, 1323002) OR DivDistance <> 272 LIMIT 28","hsqls":["SELECT MIN(OriginStateFips), MAX(FirstDepTime), AVG(DestAirportID) FROM mytable WHERE (DivAirportSeqIDs__MV0 IN (1327702, 1323002) OR DivAirportSeqIDs__MV1 IN (1327702, 1323002) OR DivAirportSeqIDs__MV2 IN (1327702, 1323002) OR DivAirportSeqIDs__MV3 IN (1327702, 1323002) OR DivAirportSeqIDs__MV4 IN (1327702, 132300 [...]
+{"sql":"SELECT MIN(OriginStateFips), SUM(FirstDepTime) FROM mytable WHERE DivAirports > 'PSG' LIMIT 17","hsqls":["SELECT MIN(OriginStateFips), SUM(FirstDepTime) FROM mytable WHERE (DivAirports__MV0 > 'PSG' OR DivAirports__MV1 > 'PSG' OR DivAirports__MV2 > 'PSG' OR DivAirports__MV3 > 'PSG' OR DivAirports__MV4 > 'PSG') LIMIT 10000"]}
+{"sql":"SELECT MIN(OriginWac) FROM mytable WHERE DivAirportIDs <= 12335 LIMIT 20","hsqls":["SELECT MIN(OriginWac) FROM mytable WHERE (DivAirportIDs__MV0 <= 12335 OR DivAirportIDs__MV1 <= 12335 OR DivAirportIDs__MV2 <= 12335 OR DivAirportIDs__MV3 <= 12335 OR DivAirportIDs__MV4 <= 12335) LIMIT 10000"]}
+{"sql":"SELECT MIN(Quarter), SUM(DestAirportID), MIN(TaxiOut) FROM mytable WHERE DestState BETWEEN 'CT' AND 'SC' OR Origin IN ('SJU', 'MGM', 'ORF', 'STT', 'GSO') AND DestCityName NOT IN ('Valdosta, GA', 'San Antonio, TX', 'Alexandria, LA') LIMIT 10"}
+{"sql":"SELECT MIN(WheelsOn), SUM(DivDistance) FROM mytable WHERE DivTotalGTimes IN (1, 59, 44, 56, 201)","hsqls":["SELECT MIN(WheelsOn), SUM(DivDistance) FROM mytable WHERE (DivTotalGTimes__MV0 IN (1, 59, 44, 56, 201) OR DivTotalGTimes__MV1 IN (1, 59, 44, 56, 201) OR DivTotalGTimes__MV2 IN (1, 59, 44, 56, 201) OR DivTotalGTimes__MV3 IN (1, 59, 44, 56, 201) OR DivTotalGTimes__MV4 IN (1, 59, 44, 56, 201)) LIMIT 10000"]}
+{"sql":"SELECT MIN(\"Month\"), MIN(Distance), AVG(DivAirportLandings) FROM mytable WHERE OriginStateFips NOT IN (48, 6, 33, 38) LIMIT 23","hsqls":["SELECT MIN(Month), MIN(Distance), AVG(DivAirportLandings) FROM mytable WHERE OriginStateFips NOT IN (48, 6, 33, 38) LIMIT 23"]}
+{"sql":"SELECT MIN(\"Year\"), COUNT(DestWac), MAX(DestCityMarketID) FROM mytable WHERE DivWheelsOns IN (1724, 1120, 723, 1613) OR FlightNum < 2412 LIMIT 2","hsqls":["SELECT MIN(Year), COUNT(DestWac), MAX(DestCityMarketID) FROM mytable WHERE (DivWheelsOns__MV0 IN (1724, 1120, 723, 1613) OR DivWheelsOns__MV1 IN (1724, 1120, 723, 1613) OR DivWheelsOns__MV2 IN (1724, 1120, 723, 1613) OR DivWheelsOns__MV3 IN (1724, 1120, 723, 1613) OR DivWheelsOns__MV4 IN (1724, 1120, 723, 1613)) OR FlightNu [...]
+{"sql":"SELECT MIN(\"Year\"), MAX(ArrivalDelayGroups) FROM mytable WHERE ArrTimeBlk NOT IN ('2200-2259', '1200-1259', '0001-0559', '1400-1459', '1800-1859') LIMIT 1","hsqls":["SELECT MIN(Year), MAX(ArrivalDelayGroups) FROM mytable WHERE ArrTimeBlk NOT IN ('2200-2259', '1200-1259', '0001-0559', '1400-1459', '1800-1859') LIMIT 1"]}
+{"sql":"SELECT SUM(AirlineID) FROM mytable WHERE WeatherDelay <= 52 OR Cancelled IN (1) AND DivAirportIDs IN (11953) LIMIT 11","hsqls":["SELECT SUM(AirlineID) FROM mytable WHERE WeatherDelay <= 52 OR Cancelled IN (1) AND (DivAirportIDs__MV0 IN (11953) OR DivAirportIDs__MV1 IN (11953) OR DivAirportIDs__MV2 IN (11953) OR DivAirportIDs__MV3 IN (11953) OR DivAirportIDs__MV4 IN (11953)) LIMIT 10000"]}
+{"sql":"SELECT SUM(ArrDelay), SUM(DestAirportID), SUM(Distance) FROM mytable WHERE DestCityMarketID BETWEEN 30325 AND 32467 OR \"Year\" BETWEEN 2014 AND 2014","hsqls":["SELECT SUM(ArrDelay), SUM(DestAirportID), SUM(Distance) FROM mytable WHERE DestCityMarketID BETWEEN 30325 AND 32467 OR Year BETWEEN 2014 AND 2014"]}
+{"sql":"SELECT SUM(ArrDelayMinutes), COUNT(OriginWac), MAX(FlightNum) FROM mytable WHERE DivAirportIDs >= 13830 AND CRSElapsedTime <= 553 LIMIT 20","hsqls":["SELECT SUM(ArrDelayMinutes), COUNT(OriginWac), MAX(FlightNum) FROM mytable WHERE (DivAirportIDs__MV0 >= 13830 OR DivAirportIDs__MV1 >= 13830 OR DivAirportIDs__MV2 >= 13830 OR DivAirportIDs__MV3 >= 13830 OR DivAirportIDs__MV4 >= 13830) AND CRSElapsedTime <= 553 LIMIT 10000"]}
+{"sql":"SELECT SUM(CRSArrTime), AVG(FirstDepTime), AVG(OriginAirportID) FROM mytable WHERE OriginCityMarketID NOT IN (31205, 31624, 30980, 31097) AND DivAirports >= 'ELP' LIMIT 10","hsqls":["SELECT SUM(CRSArrTime), AVG(FirstDepTime), AVG(OriginAirportID) FROM mytable WHERE OriginCityMarketID NOT IN (31205, 31624, 30980, 31097) AND (DivAirports__MV0 >= 'ELP' OR DivAirports__MV1 >= 'ELP' OR DivAirports__MV2 >= 'ELP' OR DivAirports__MV3 >= 'ELP' OR DivAirports__MV4 >= 'ELP') LIMIT 10000"]}
+{"sql":"SELECT SUM(DaysSinceEpoch), AVG(DepartureDelayGroups) FROM mytable WHERE DivAirports BETWEEN 'MSP' AND 'SAT' AND OriginWac < 66 OR DivDistance <= 328 LIMIT 20","hsqls":["SELECT SUM(DaysSinceEpoch), AVG(DepartureDelayGroups) FROM mytable WHERE (DivAirports__MV0 BETWEEN 'MSP' AND 'SAT' OR DivAirports__MV1 BETWEEN 'MSP' AND 'SAT' OR DivAirports__MV2 BETWEEN 'MSP' AND 'SAT' OR DivAirports__MV3 BETWEEN 'MSP' AND 'SAT' OR DivAirports__MV4 BETWEEN 'MSP' AND 'SAT') AND OriginWac < 66 OR [...]
+{"sql":"SELECT SUM(DepDel15), COUNT(AirTime) FROM mytable WHERE DivTailNums IN ('N3751B', 'N296WN', 'N416SW', 'N472WN') LIMIT 7","hsqls":["SELECT SUM(DepDel15), COUNT(AirTime) FROM mytable WHERE (DivTailNums__MV0 IN ('N3751B', 'N296WN', 'N416SW', 'N472WN') OR DivTailNums__MV1 IN ('N3751B', 'N296WN', 'N416SW', 'N472WN') OR DivTailNums__MV2 IN ('N3751B', 'N296WN', 'N416SW', 'N472WN') OR DivTailNums__MV3 IN ('N3751B', 'N296WN', 'N416SW', 'N472WN') OR DivTailNums__MV4 IN ('N3751B', 'N296WN', [...]
+{"sql":"SELECT SUM(DestAirportSeqID) FROM mytable WHERE DivLongestGTimes >= 58.0 AND DayofMonth BETWEEN 20 AND 30 AND FlightDate >= '2014-01-25' LIMIT 10","hsqls":["SELECT SUM(DestAirportSeqID) FROM mytable WHERE (DivLongestGTimes__MV0 >= 58.0 OR DivLongestGTimes__MV1 >= 58.0 OR DivLongestGTimes__MV2 >= 58.0 OR DivLongestGTimes__MV3 >= 58.0 OR DivLongestGTimes__MV4 >= 58.0) AND DayofMonth BETWEEN 20 AND 30 AND FlightDate >= '2014-01-25' LIMIT 10000"]}
+{"sql":"SELECT SUM(DistanceGroup) FROM mytable WHERE CRSArrTime BETWEEN 2341 AND 931 OR DivWheelsOns IN (1642) OR DestCityName <> 'Indianapolis, IN' LIMIT 6","hsqls":["SELECT SUM(DistanceGroup) FROM mytable WHERE CRSArrTime BETWEEN 2341 AND 931 OR (DivWheelsOns__MV0 IN (1642) OR DivWheelsOns__MV1 IN (1642) OR DivWheelsOns__MV2 IN (1642) OR DivWheelsOns__MV3 IN (1642) OR DivWheelsOns__MV4 IN (1642)) OR DestCityName <> 'Indianapolis, IN' LIMIT 10000"]}
+{"sql":"SELECT SUM(DivActualElapsedTime), COUNT(LateAircraftDelay), AVG(DivActualElapsedTime) FROM mytable WHERE DivTotalGTimes > 18 AND OriginCityMarketID IN (30721, 32389, 30781, 31076) OR DepDel15 BETWEEN -9999 AND 1 LIMIT 22","hsqls":["SELECT SUM(DivActualElapsedTime), COUNT(LateAircraftDelay), AVG(DivActualElapsedTime) FROM mytable WHERE (DivTotalGTimes__MV0 > 18 OR DivTotalGTimes__MV1 > 18 OR DivTotalGTimes__MV2 > 18 OR DivTotalGTimes__MV3 > 18 OR DivTotalGTimes__MV4 > 18) AND Ori [...]
+{"sql":"SELECT SUM(DivActualElapsedTime), MAX(\"Month\") FROM mytable WHERE Distance <> 788 AND DivWheelsOffs > 1851 LIMIT 5","hsqls":["SELECT SUM(DivActualElapsedTime), MAX(Month) FROM mytable WHERE Distance <> 788 AND (DivWheelsOffs__MV0 > 1851 OR DivWheelsOffs__MV1 > 1851 OR DivWheelsOffs__MV2 > 1851 OR DivWheelsOffs__MV3 > 1851 OR DivWheelsOffs__MV4 > 1851) LIMIT 10000"]}
+{"sql":"SELECT SUM(DivArrDelay), SUM(DestStateFips) FROM mytable WHERE DivTailNums IN ('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') AND DestAirportID < 11867 OR Carrier NOT IN ('DL', 'WN') LIMIT 20","hsqls":["SELECT SUM(DivArrDelay), SUM(DestStateFips) FROM mytable WHERE (DivTailNums__MV0 IN ('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums__MV1 IN ('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums__MV2 IN ('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA' [...]
+{"sql":"SELECT SUM(DivReachedDest), AVG(DestWac) FROM mytable WHERE DivWheelsOns BETWEEN 728 AND 1804 LIMIT 13","hsqls":["SELECT SUM(DivReachedDest), AVG(DestWac) FROM mytable WHERE (DivWheelsOns__MV0 BETWEEN 728 AND 1804 OR DivWheelsOns__MV1 BETWEEN 728 AND 1804 OR DivWheelsOns__MV2 BETWEEN 728 AND 1804 OR DivWheelsOns__MV3 BETWEEN 728 AND 1804 OR DivWheelsOns__MV4 BETWEEN 728 AND 1804) LIMIT 10000"]}
+{"sql":"SELECT SUM(NASDelay), AVG(DivDistance), SUM(ActualElapsedTime) FROM mytable WHERE OriginStateName NOT IN ('Kentucky', 'South Dakota') OR DivWheelsOns <= 1038 AND DivDistance = 261","hsqls":["SELECT SUM(NASDelay), AVG(DivDistance), SUM(ActualElapsedTime) FROM mytable WHERE OriginStateName NOT IN ('Kentucky', 'South Dakota') OR (DivWheelsOns__MV0 <= 1038 OR DivWheelsOns__MV1 <= 1038 OR DivWheelsOns__MV2 <= 1038 OR DivWheelsOns__MV3 <= 1038 OR DivWheelsOns__MV4 <= 1038) AND DivDist [...]
+{"sql":"SELECT SUM(SecurityDelay) FROM mytable WHERE DivTailNums < 'N712SW' OR Distance BETWEEN 426 AND 994 AND TaxiIn BETWEEN 65 AND 9 LIMIT 17","hsqls":["SELECT SUM(SecurityDelay) FROM mytable WHERE (DivTailNums__MV0 < 'N712SW' OR DivTailNums__MV1 < 'N712SW' OR DivTailNums__MV2 < 'N712SW' OR DivTailNums__MV3 < 'N712SW' OR DivTailNums__MV4 < 'N712SW') OR Distance BETWEEN 426 AND 994 AND TaxiIn BETWEEN 65 AND 9 LIMIT 10000"]}
+{"sql":"SELECT SUM(TaxiOut) FROM mytable WHERE WeatherDelay <> 123 OR DivWheelsOffs IN (1352, 1758) OR DistanceGroup NOT IN (5) LIMIT 14","hsqls":["SELECT SUM(TaxiOut) FROM mytable WHERE WeatherDelay <> 123 OR (DivWheelsOffs__MV0 IN (1352, 1758) OR DivWheelsOffs__MV1 IN (1352, 1758) OR DivWheelsOffs__MV2 IN (1352, 1758) OR DivWheelsOffs__MV3 IN (1352, 1758) OR DivWheelsOffs__MV4 IN (1352, 1758)) OR DistanceGroup NOT IN (5) LIMIT 10000"]}
+{"sql":"SELECT SUM(TaxiOut), MIN(\"Month\"), SUM(SecurityDelay) FROM mytable WHERE DestWac BETWEEN 88 AND 85 AND DepDelay <> 158.0 OR DivAirportIDs BETWEEN 10136 AND 10713 LIMIT 4","hsqls":["SELECT SUM(TaxiOut), MIN(Month), SUM(SecurityDelay) FROM mytable WHERE DestWac BETWEEN 88 AND 85 AND DepDelay <> 158.0 OR (DivAirportIDs__MV0 BETWEEN 10136 AND 10713 OR DivAirportIDs__MV1 BETWEEN 10136 AND 10713 OR DivAirportIDs__MV2 BETWEEN 10136 AND 10713 OR DivAirportIDs__MV3 BETWEEN 10136 AND 10 [...]
+{"sql":"SELECT SUM(TotalAddGTime) FROM mytable WHERE AirlineID <> 20304 AND \"Year\" BETWEEN 2014 AND 2014 AND Quarter IN (1) LIMIT 16","hsqls":["SELECT SUM(TotalAddGTime) FROM mytable WHERE AirlineID <> 20304 AND Year BETWEEN 2014 AND 2014 AND Quarter IN (1) LIMIT 16"]}
+{"sql":"SELECT SUM(WheelsOff) FROM mytable WHERE DivAirportIDs IN (11292, 11986, 12819, 13424, 16271) OR FlightNum BETWEEN 4294 AND 5280 LIMIT 27","hsqls":["SELECT SUM(WheelsOff) FROM mytable WHERE (DivAirportIDs__MV0 IN (11292, 11986, 12819, 13424, 16271) OR DivAirportIDs__MV1 IN (11292, 11986, 12819, 13424, 16271) OR DivAirportIDs__MV2 IN (11292, 11986, 12819, 13424, 16271) OR DivAirportIDs__MV3 IN (11292, 11986, 12819, 13424, 16271) OR DivAirportIDs__MV4 IN (11292, 11986, 12819, 13424 [...]
+{"sql":"SELECT SUM(WheelsOff), AVG(Diverted), SUM(Distance) FROM mytable WHERE DivTotalGTimes >= 53 LIMIT 18","hsqls":["SELECT SUM(WheelsOff), AVG(Diverted), SUM(Distance) FROM mytable WHERE (DivTotalGTimes__MV0 >= 53 OR DivTotalGTimes__MV1 >= 53 OR DivTotalGTimes__MV2 >= 53 OR DivTotalGTimes__MV3 >= 53 OR DivTotalGTimes__MV4 >= 53) LIMIT 10000"]}
+{"sql":"SELECT SUM(WheelsOff), MIN(DivReachedDest), MAX(TaxiOut) FROM mytable WHERE DivLongestGTimes > 39.0 LIMIT 9","hsqls":["SELECT SUM(WheelsOff), MIN(DivReachedDest), MAX(TaxiOut) FROM mytable WHERE (DivLongestGTimes__MV0 > 39.0 OR DivLongestGTimes__MV1 > 39.0 OR DivLongestGTimes__MV2 > 39.0 OR DivLongestGTimes__MV3 > 39.0 OR DivLongestGTimes__MV4 > 39.0) LIMIT 10000"]}
+{"sql":"SELECT SUM(WheelsOn), MAX(SecurityDelay), SUM(DestAirportSeqID) FROM mytable WHERE Distance <= 1085 OR ArrDel15 BETWEEN 1 AND 0 OR DivTotalGTimes = 79 LIMIT 24","hsqls":["SELECT SUM(WheelsOn), MAX(SecurityDelay), SUM(DestAirportSeqID) FROM mytable WHERE Distance <= 1085 OR ArrDel15 BETWEEN 1 AND 0 OR (DivTotalGTimes__MV0 = 79 OR DivTotalGTimes__MV1 = 79 OR DivTotalGTimes__MV2 = 79 OR DivTotalGTimes__MV3 = 79 OR DivTotalGTimes__MV4 = 79) LIMIT 10000"]}
+{"sql":"SELECT SUM(WheelsOn), MIN(\"Year\"), MIN(\"Month\") FROM mytable WHERE ArrivalDelayGroups BETWEEN 5 AND 7 AND OriginAirportID <= 14570 LIMIT 4","hsqls":["SELECT SUM(WheelsOn), MIN(Year), MIN(Month) FROM mytable WHERE ArrivalDelayGroups BETWEEN 5 AND 7 AND OriginAirportID <= 14570 LIMIT 4"]}
+{"sql":"SELECT SUM(WheelsOn), SUM(DepDelayMinutes), MAX(CRSElapsedTime) FROM mytable WHERE TailNum <= 'N792SW' OR LateAircraftDelay = 33 OR DivWheelsOns IN (1301, 1517) LIMIT 19","hsqls":["SELECT SUM(WheelsOn), SUM(DepDelayMinutes), MAX(CRSElapsedTime) FROM mytable WHERE TailNum <= 'N792SW' OR LateAircraftDelay = 33 OR (DivWheelsOns__MV0 IN (1301, 1517) OR DivWheelsOns__MV1 IN (1301, 1517) OR DivWheelsOns__MV2 IN (1301, 1517) OR DivWheelsOns__MV3 IN (1301, 1517) OR DivWheelsOns__MV4 IN ( [...]
+{"sql":"SELECT SUM(WheelsOn), SUM(DivArrDelay), COUNT(DestState) FROM mytable WHERE DivAirports IN ('RFD') AND TaxiIn BETWEEN -9999 AND 94 LIMIT 29","hsqls":["SELECT SUM(WheelsOn), SUM(DivArrDelay), COUNT(DestState) FROM mytable WHERE (DivAirports__MV0 IN ('RFD') OR DivAirports__MV1 IN ('RFD') OR DivAirports__MV2 IN ('RFD') OR DivAirports__MV3 IN ('RFD') OR DivAirports__MV4 IN ('RFD')) AND TaxiIn BETWEEN -9999 AND 94 LIMIT 10000"]}
+{"sql":"SELECT SUM(\"Month\") FROM mytable WHERE FirstDepTime <> 1742 AND DestStateName BETWEEN 'Maine' AND 'South Dakota' OR Carrier <= 'UA' LIMIT 23","hsqls":["SELECT SUM(Month) FROM mytable WHERE FirstDepTime <> 1742 AND DestStateName BETWEEN 'Maine' AND 'South Dakota' OR Carrier <= 'UA' LIMIT 23"]}
+{"sql":"SELECT SUM(\"Month\"), MAX(Quarter) FROM mytable WHERE WheelsOff < 1848 OR OriginCityName NOT IN ('Albany, NY', 'Cincinnati, OH', 'Lewiston, ID', 'Reno, NV', 'Fort Lauderdale, FL') LIMIT 18","hsqls":["SELECT SUM(Month), MAX(Quarter) FROM mytable WHERE WheelsOff < 1848 OR OriginCityName NOT IN ('Albany, NY', 'Cincinnati, OH', 'Lewiston, ID', 'Reno, NV', 'Fort Lauderdale, FL') LIMIT 18"]}
+{"sql":"SELECT SUM(\"Year\"), COUNT(ArrTime) FROM mytable WHERE OriginCityMarketID NOT IN (32457, 33795, 33495, 31049) OR DestWac BETWEEN 65 AND 87 OR OriginState NOT IN ('ND', 'CO') LIMIT 29","hsqls":["SELECT SUM(Year), COUNT(ArrTime) FROM mytable WHERE OriginCityMarketID NOT IN (32457, 33795, 33495, 31049) OR DestWac BETWEEN 65 AND 87 OR OriginState NOT IN ('ND', 'CO') LIMIT 29"]}
+{"sql":"SELECT SUM(\"Year\"), MAX(DayofMonth), AVG(CRSArrTime) FROM mytable WHERE WheelsOff > 1737 AND DivTotalGTimes IN (30, 113, 102, 37) LIMIT 10","hsqls":["SELECT SUM(Year), MAX(DayofMonth), AVG(CRSArrTime) FROM mytable WHERE WheelsOff > 1737 AND (DivTotalGTimes__MV0 IN (30, 113, 102, 37) OR DivTotalGTimes__MV1 IN (30, 113, 102, 37) OR DivTotalGTimes__MV2 IN (30, 113, 102, 37) OR DivTotalGTimes__MV3 IN (30, 113, 102, 37) OR DivTotalGTimes__MV4 IN (30, 113, 102, 37)) LIMIT 10000"]}
+
+# Filtering & Grouping on Aggregation
+{"sql":"SELECT ActualElapsedTime, AirTime, MIN(DistanceGroup), SUM(OriginAirportSeqID) FROM mytable WHERE ArrTime BETWEEN 2017 AND 2216 GROUP BY ActualElapsedTime, AirTime ORDER BY ActualElapsedTime, AirTime LIMIT 14","hsqls":["SELECT ActualElapsedTime, AirTime, MIN(DistanceGroup), SUM(OriginAirportSeqID) FROM mytable WHERE ArrTime BETWEEN 2017 AND 2216 GROUP BY ActualElapsedTime, AirTime ORDER BY ActualElapsedTime, AirTime LIMIT 14"]}
+{"sql":"SELECT ActualElapsedTime, SUM(DivReachedDest), MAX(DepDelay) FROM mytable WHERE DestAirportID BETWEEN 10551 AND 10792 GROUP BY ActualElapsedTime ORDER BY ActualElapsedTime LIMIT 15","hsqls":["SELECT ActualElapsedTime, SUM(DivReachedDest), MAX(DepDelay) FROM mytable WHERE DestAirportID BETWEEN 10551 AND 10792 GROUP BY ActualElapsedTime ORDER BY ActualElapsedTime LIMIT 15"]}
+{"sql":"SELECT AirlineID, AVG(DepDelay) FROM mytable WHERE OriginCityMarketID NOT IN (32457, 30894, 34489, 34254) OR WheelsOn <= 552 GROUP BY AirlineID ORDER BY AirlineID LIMIT 29","hsqls":["SELECT AirlineID, AVG(DepDelay) FROM mytable WHERE OriginCityMarketID NOT IN (32457, 30894, 34489, 34254) OR WheelsOn <= 552 GROUP BY AirlineID ORDER BY AirlineID LIMIT 29"]}
+{"sql":"SELECT ArrDel15, MAX(TotalAddGTime), COUNT(DestAirportID) FROM mytable WHERE TailNum BETWEEN 'N11565' AND 'N703SW' GROUP BY ArrDel15 ORDER BY ArrDel15 LIMIT 20","hsqls":["SELECT ArrDel15, MAX(TotalAddGTime), COUNT(DestAirportID) FROM mytable WHERE TailNum BETWEEN 'N11565' AND 'N703SW' GROUP BY ArrDel15 ORDER BY ArrDel15 LIMIT 20"]}
+{"sql":"SELECT ArrDelay, MIN(CRSElapsedTime) FROM mytable WHERE Diverted = 0 OR DivArrDelay NOT IN (183, 472, 119) GROUP BY ArrDelay ORDER BY ArrDelay LIMIT 1","hsqls":["SELECT ArrDelay, MIN(CRSElapsedTime) FROM mytable WHERE Diverted = 0 OR DivArrDelay NOT IN (183, 472, 119) GROUP BY ArrDelay ORDER BY ArrDelay LIMIT 1"]}
+{"sql":"SELECT ArrDelayMinutes, OriginStateName, SUM(DestWac) FROM mytable WHERE OriginAirportSeqID >= 1217703 GROUP BY ArrDelayMinutes, OriginStateName ORDER BY ArrDelayMinutes, OriginStateName LIMIT 4","hsqls":["SELECT ArrDelayMinutes, OriginStateName, SUM(DestWac) FROM mytable WHERE OriginAirportSeqID >= 1217703 GROUP BY ArrDelayMinutes, OriginStateName ORDER BY ArrDelayMinutes, OriginStateName LIMIT 4"]}
+{"sql":"SELECT ArrTime, AVG(DayOfWeek), MIN(DistanceGroup) FROM mytable WHERE ArrDel15 IN (1, 0, -9999) AND ArrDelay NOT IN (54.0) GROUP BY ArrTime ORDER BY ArrTime LIMIT 25","hsqls":["SELECT ArrTime, AVG(DayOfWeek), MIN(DistanceGroup) FROM mytable WHERE ArrDel15 IN (1, 0, -9999) AND ArrDelay NOT IN (54.0) GROUP BY ArrTime ORDER BY ArrTime LIMIT 25"]}
+{"sql":"SELECT ArrTimeBlk, Dest, ArrivalDelayGroups, COUNT(*) FROM mytable WHERE Distance BETWEEN 448 AND 4502 OR OriginWac BETWEEN 43 AND 63 OR FlightNum NOT IN (1601, 2918, 1415, 2179, 110) GROUP BY ArrTimeBlk, Dest, ArrivalDelayGroups ORDER BY ArrTimeBlk, Dest, ArrivalDelayGroups LIMIT 14","hsqls":["SELECT ArrTimeBlk, Dest, ArrivalDelayGroups, COUNT(*) FROM mytable WHERE Distance BETWEEN 448 AND 4502 OR OriginWac BETWEEN 43 AND 63 OR FlightNum NOT IN (1601, 2918, 1415, 2179, 110) GRO [...]
+{"sql":"SELECT ArrivalDelayGroups, MIN(DepDel15), MAX(DestCityMarketID), COUNT(TailNum) FROM mytable WHERE DestAirportSeqID NOT IN (1114603, 1114002) GROUP BY ArrivalDelayGroups ORDER BY ArrivalDelayGroups LIMIT 24","hsqls":["SELECT ArrivalDelayGroups, MIN(DepDel15), MAX(DestCityMarketID), COUNT(TailNum) FROM mytable WHERE DestAirportSeqID NOT IN (1114603, 1114002) GROUP BY ArrivalDelayGroups ORDER BY ArrivalDelayGroups LIMIT 24"]}
+{"sql":"SELECT CRSArrTime, SUM(DayofMonth), SUM(ArrTime) FROM mytable WHERE DaysSinceEpoch IN (16095, 16079) AND DivAirportLandings BETWEEN 1 AND 2 OR DestCityName <= 'Tucson, AZ' GROUP BY CRSArrTime ORDER BY CRSArrTime LIMIT 22","hsqls":["SELECT CRSArrTime, SUM(DayofMonth), SUM(ArrTime) FROM mytable WHERE DaysSinceEpoch IN (16095, 16079) AND DivAirportLandings BETWEEN 1 AND 2 OR DestCityName <= 'Tucson, AZ' GROUP BY CRSArrTime ORDER BY CRSArrTime LIMIT 22"]}
+{"sql":"SELECT CRSElapsedTime, MAX(SecurityDelay), AVG(Diverted), COUNT(UniqueCarrier) FROM mytable WHERE DivArrDelay NOT IN (128, 199, 232, 626, 81) AND CancellationCode BETWEEN 'A' AND 'C' GROUP BY CRSElapsedTime ORDER BY CRSElapsedTime LIMIT 1","hsqls":["SELECT CRSElapsedTime, MAX(SecurityDelay), AVG(Diverted), COUNT(UniqueCarrier) FROM mytable WHERE DivArrDelay NOT IN (128, 199, 232, 626, 81) AND CancellationCode BETWEEN 'A' AND 'C' GROUP BY CRSElapsedTime ORDER BY CRSElapsedTime L [...]
+{"sql":"SELECT CancellationCode, COUNT(*) FROM mytable WHERE TailNum IN ('N3BHAA', 'N710SK', 'N3KYAA', 'N291AT') AND DivAirportLandings BETWEEN 2 AND 1 OR CancellationCode NOT IN ('A', 'noodles') GROUP BY CancellationCode ORDER BY CancellationCode LIMIT 20","hsqls":["SELECT CancellationCode, COUNT(*) FROM mytable WHERE TailNum IN ('N3BHAA', 'N710SK', 'N3KYAA', 'N291AT') AND DivAirportLandings BETWEEN 2 AND 1 OR CancellationCode NOT IN ('A', 'noodles') GROUP BY CancellationCode ORDER BY [...]
+{"sql":"SELECT CancellationCode, SUM(WheelsOn), MIN(DaysSinceEpoch), MIN(AirlineID) FROM mytable WHERE Quarter NOT IN (1) OR Cancelled BETWEEN 1 AND 0 GROUP BY CancellationCode ORDER BY CancellationCode LIMIT 29","hsqls":["SELECT CancellationCode, SUM(WheelsOn), MIN(DaysSinceEpoch), MIN(AirlineID) FROM mytable WHERE Quarter NOT IN (1) OR Cancelled BETWEEN 1 AND 0 GROUP BY CancellationCode ORDER BY CancellationCode LIMIT 29"]}
+{"sql":"SELECT Cancelled, AirTime, COUNT(Origin), MIN(DaysSinceEpoch), MIN(AirlineID) FROM mytable WHERE FlightNum >= 1921 GROUP BY Cancelled, AirTime ORDER BY Cancelled, AirTime LIMIT 22","hsqls":["SELECT Cancelled, AirTime, COUNT(Origin), MIN(DaysSinceEpoch), MIN(AirlineID) FROM mytable WHERE FlightNum >= 1921 GROUP BY Cancelled, AirTime ORDER BY Cancelled, AirTime LIMIT 22"]}
+{"sql":"SELECT Cancelled, DestStateName, MIN(FlightNum), MAX(LongestAddGTime), AVG(DivArrDelay) FROM mytable WHERE DivArrDelay NOT IN (95, 406, 106, 62, 234) OR OriginStateFips BETWEEN 47 AND 33 AND DestState IN ('MI', 'NH', 'KY', 'NY', 'ME') GROUP BY Cancelled, DestStateName ORDER BY Cancelled, DestStateName LIMIT 22","hsqls":["SELECT Cancelled, DestStateName, MIN(FlightNum), MAX(LongestAddGTime), AVG(DivArrDelay) FROM mytable WHERE DivArrDelay NOT IN (95, 406, 106, 62, 234) OR OriginS [...]
+{"sql":"SELECT Carrier, ArrTime, Origin, SUM(ArrDelay), MAX(DivReachedDest) FROM mytable WHERE Quarter IN (1) GROUP BY Carrier, ArrTime, Origin ORDER BY Carrier, ArrTime, Origin LIMIT 10","hsqls":["SELECT Carrier, ArrTime, Origin, SUM(ArrDelay), MAX(DivReachedDest) FROM mytable WHERE Quarter IN (1) GROUP BY Carrier, ArrTime, Origin ORDER BY Carrier, ArrTime, Origin LIMIT 10"]}
+{"sql":"SELECT Carrier, FlightDate, DestCityName, COUNT(*) FROM mytable WHERE DepTimeBlk <= '0900-0959' GROUP BY Carrier, FlightDate, DestCityName ORDER BY Carrier, FlightDate, DestCityName LIMIT 6","hsqls":["SELECT Carrier, FlightDate, DestCityName, COUNT(*) FROM mytable WHERE DepTimeBlk <= '0900-0959' GROUP BY Carrier, FlightDate, DestCityName ORDER BY Carrier, FlightDate, DestCityName LIMIT 6"]}
+{"sql":"SELECT Carrier, OriginAirportID, COUNT(Dest) FROM mytable WHERE WeatherDelay IN (170, 20, 123) OR WheelsOff <= 1752 GROUP BY Carrier, OriginAirportID ORDER BY Carrier, OriginAirportID LIMIT 15","hsqls":["SELECT Carrier, OriginAirportID, COUNT(Dest) FROM mytable WHERE WeatherDelay IN (170, 20, 123) OR WheelsOff <= 1752 GROUP BY Carrier, OriginAirportID ORDER BY Carrier, OriginAirportID LIMIT 15"]}
+{"sql":"SELECT CarrierDelay, DivAirportLandings, MAX(WheelsOff), MIN(DivReachedDest) FROM mytable WHERE OriginStateName NOT IN ('Minnesota', 'Hawaii', 'Montana', 'Nevada', 'Oklahoma') GROUP BY CarrierDelay, DivAirportLandings ORDER BY CarrierDelay, DivAirportLandings LIMIT 9","hsqls":["SELECT CarrierDelay, DivAirportLandings, MAX(WheelsOff), MIN(DivReachedDest) FROM mytable WHERE OriginStateName NOT IN ('Minnesota', 'Hawaii', 'Montana', 'Nevada', 'Oklahoma') GROUP BY CarrierDelay, DivAi [...]
+{"sql":"SELECT DayOfWeek, MIN(ArrDel15), MIN(DepDelay), MAX(WeatherDelay) FROM mytable WHERE TaxiIn <> 94 OR Quarter BETWEEN 1 AND 1 AND AirlineID NOT IN (19690) GROUP BY DayOfWeek ORDER BY DayOfWeek LIMIT 25","hsqls":["SELECT DayOfWeek, MIN(ArrDel15), MIN(DepDelay), MAX(WeatherDelay) FROM mytable WHERE TaxiIn <> 94 OR Quarter BETWEEN 1 AND 1 AND AirlineID NOT IN (19690) GROUP BY DayOfWeek ORDER BY DayOfWeek LIMIT 25"]}
+{"sql":"SELECT DayofMonth, SUM(CRSArrTime), MIN(CRSElapsedTime) FROM mytable WHERE ArrDelay <> 364.0 GROUP BY DayofMonth ORDER BY DayofMonth LIMIT 2","hsqls":["SELECT DayofMonth, SUM(CRSArrTime), MIN(CRSElapsedTime) FROM mytable WHERE ArrDelay <> 364.0 GROUP BY DayofMonth ORDER BY DayofMonth LIMIT 2"]}
+{"sql":"SELECT DaysSinceEpoch, COUNT(ArrivalDelayGroups), MAX(TaxiIn), MAX(CRSDepTime) FROM mytable WHERE ArrTimeBlk NOT IN ('2200-2259') GROUP BY DaysSinceEpoch ORDER BY DaysSinceEpoch LIMIT 5","hsqls":["SELECT DaysSinceEpoch, COUNT(ArrivalDelayGroups), MAX(TaxiIn), MAX(CRSDepTime) FROM mytable WHERE ArrTimeBlk NOT IN ('2200-2259') GROUP BY DaysSinceEpoch ORDER BY DaysSinceEpoch LIMIT 5"]}
+{"sql":"SELECT DepDel15, CRSElapsedTime, DaysSinceEpoch, MIN(Distance), AVG(DivActualElapsedTime) FROM mytable WHERE ArrivalDelayGroups NOT IN (3, 10, 6) GROUP BY DepDel15, CRSElapsedTime, DaysSinceEpoch ORDER BY DepDel15, CRSElapsedTime, DaysSinceEpoch LIMIT 15","hsqls":["SELECT DepDel15, CRSElapsedTime, DaysSinceEpoch, MIN(Distance), AVG(DivActualElapsedTime) FROM mytable WHERE ArrivalDelayGroups NOT IN (3, 10, 6) GROUP BY DepDel15, CRSElapsedTime, DaysSinceEpoch ORDER BY DepDel15, C [...]
+{"sql":"SELECT DepDelay, CRSArrTime, SecurityDelay, MIN(OriginStateFips), SUM(CRSElapsedTime), MIN(DivArrDelay) FROM mytable WHERE WeatherDelay > 115 GROUP BY DepDelay, CRSArrTime, SecurityDelay ORDER BY DepDelay, CRSArrTime, SecurityDelay LIMIT 29","hsqls":["SELECT DepDelay, CRSArrTime, SecurityDelay, MIN(OriginStateFips), SUM(CRSElapsedTime), MIN(DivArrDelay) FROM mytable WHERE WeatherDelay > 115 GROUP BY DepDelay, CRSArrTime, SecurityDelay ORDER BY DepDelay, CRSArrTime, SecurityDela [...]
+{"sql":"SELECT DepDelay, DestStateName, NASDelay, COUNT(OriginCityName) FROM mytable WHERE OriginAirportSeqID IN (1457604, 1082103, 1142303, 1397002, 1125903) AND FlightNum BETWEEN 1033 AND 3130 GROUP BY DepDelay, DestStateName, NASDelay ORDER BY DepDelay, DestStateName, NASDelay LIMIT 7","hsqls":["SELECT DepDelay, DestStateName, NASDelay, COUNT(OriginCityName) FROM mytable WHERE OriginAirportSeqID IN (1457604, 1082103, 1142303, 1397002, 1125903) AND FlightNum BETWEEN 1033 AND 3130 GROU [...]
+{"sql":"SELECT DepDelay, MIN(WheelsOn) FROM mytable WHERE WheelsOn BETWEEN 1238 AND 2350 GROUP BY DepDelay ORDER BY DepDelay LIMIT 16","hsqls":["SELECT DepDelay, MIN(WheelsOn) FROM mytable WHERE WheelsOn BETWEEN 1238 AND 2350 GROUP BY DepDelay ORDER BY DepDelay LIMIT 16"]}
+{"sql":"SELECT DepDelayMinutes, CancellationCode, MIN(OriginAirportID), AVG(DaysSinceEpoch), SUM(DistanceGroup) FROM mytable WHERE ArrTimeBlk NOT IN ('0600-0659', '1800-1859') GROUP BY DepDelayMinutes, CancellationCode ORDER BY DepDelayMinutes, CancellationCode LIMIT 2","hsqls":["SELECT DepDelayMinutes, CancellationCode, MIN(OriginAirportID), AVG(DaysSinceEpoch), SUM(DistanceGroup) FROM mytable WHERE ArrTimeBlk NOT IN ('0600-0659', '1800-1859') GROUP BY DepDelayMinutes, CancellationCode [...]
+{"sql":"SELECT DepDelayMinutes, NASDelay, OriginStateName, MIN(ArrDelayMinutes), COUNT(Distance) FROM mytable WHERE CancellationCode IN ('A', 'B', 'C', 'noodles') GROUP BY DepDelayMinutes, NASDelay, OriginStateName ORDER BY DepDelayMinutes, NASDelay, OriginStateName LIMIT 4","hsqls":["SELECT DepDelayMinutes, NASDelay, OriginStateName, MIN(ArrDelayMinutes), COUNT(Distance) FROM mytable WHERE CancellationCode IN ('A', 'B', 'C', 'noodles') GROUP BY DepDelayMinutes, NASDelay, OriginStateNam [...]
+{"sql":"SELECT DepTime, CRSDepTime, WheelsOn, COUNT(SecurityDelay) FROM mytable WHERE Cancelled <= 1 OR DivReachedDest < 0 AND OriginStateFips < 27 GROUP BY DepTime, CRSDepTime, WheelsOn ORDER BY DepTime, CRSDepTime, WheelsOn LIMIT 2","hsqls":["SELECT DepTime, CRSDepTime, WheelsOn, COUNT(SecurityDelay) FROM mytable WHERE Cancelled <= 1 OR DivReachedDest < 0 AND OriginStateFips < 27 GROUP BY DepTime, CRSDepTime, WheelsOn ORDER BY DepTime, CRSDepTime, WheelsOn LIMIT 2"]}
+{"sql":"SELECT DepTimeBlk, MAX(Flights) FROM mytable WHERE OriginCityMarketID BETWEEN 30721 AND 31953 AND DivActualElapsedTime NOT IN (172, 200, 499, 345, 321) GROUP BY DepTimeBlk ORDER BY DepTimeBlk LIMIT 25","hsqls":["SELECT DepTimeBlk, MAX(Flights) FROM mytable WHERE OriginCityMarketID BETWEEN 30721 AND 31953 AND DivActualElapsedTime NOT IN (172, 200, 499, 345, 321) GROUP BY DepTimeBlk ORDER BY DepTimeBlk LIMIT 25"]}
+{"sql":"SELECT DepartureDelayGroups, CarrierDelay, COUNT(*) FROM mytable WHERE WeatherDelay NOT IN (170, 74, 84) GROUP BY DepartureDelayGroups, CarrierDelay ORDER BY DepartureDelayGroups, CarrierDelay LIMIT 26","hsqls":["SELECT DepartureDelayGroups, CarrierDelay, COUNT(*) FROM mytable WHERE WeatherDelay NOT IN (170, 74, 84) GROUP BY DepartureDelayGroups, CarrierDelay ORDER BY DepartureDelayGroups, CarrierDelay LIMIT 26"]}
+{"sql":"SELECT DepartureDelayGroups, Flights, DepDelayMinutes, MAX(NASDelay), AVG(DayofMonth), SUM(FlightNum) FROM mytable WHERE DepDel15 BETWEEN 1 AND 0 AND AirTime BETWEEN 354 AND 246 OR DistanceGroup <= 3 GROUP BY DepartureDelayGroups, Flights, DepDelayMinutes ORDER BY DepartureDelayGroups, Flights, DepDelayMinutes LIMIT 4","hsqls":["SELECT DepartureDelayGroups, Flights, DepDelayMinutes, MAX(NASDelay), AVG(DayofMonth), SUM(FlightNum) FROM mytable WHERE DepDel15 BETWEEN 1 AND 0 AND Ai [...]
+{"sql":"SELECT Dest, ArrDelay, AVG(DestStateFips), COUNT(ArrTimeBlk) FROM mytable WHERE DepDelayMinutes BETWEEN 146.0 AND 397.0 OR CancellationCode <= 'B' GROUP BY Dest, ArrDelay ORDER BY Dest, ArrDelay LIMIT 7","hsqls":["SELECT Dest, ArrDelay, AVG(DestStateFips), COUNT(ArrTimeBlk) FROM mytable WHERE DepDelayMinutes BETWEEN 146.0 AND 397.0 OR CancellationCode <= 'B' GROUP BY Dest, ArrDelay ORDER BY Dest, ArrDelay LIMIT 7"]}
+{"sql":"SELECT Dest, MIN(TotalAddGTime) FROM mytable WHERE DestStateFips IN (49, 5, 17, 37) OR DestCityMarketID BETWEEN 30325 AND 30615 GROUP BY Dest ORDER BY Dest LIMIT 10","hsqls":["SELECT Dest, MIN(TotalAddGTime) FROM mytable WHERE DestStateFips IN (49, 5, 17, 37) OR DestCityMarketID BETWEEN 30325 AND 30615 GROUP BY Dest ORDER BY Dest LIMIT 10"]}
+{"sql":"SELECT DestAirportID, CRSDepTime, OriginAirportID, AVG(AirTime), SUM(OriginCityMarketID) FROM mytable WHERE ArrDel15 BETWEEN -9999 AND -9999 OR DestStateName IN ('Utah', 'Idaho', 'Virginia', 'Arizona', 'Indiana') GROUP BY DestAirportID, CRSDepTime, OriginAirportID ORDER BY DestAirportID, CRSDepTime, OriginAirportID LIMIT 25","hsqls":["SELECT DestAirportID, CRSDepTime, OriginAirportID, AVG(AirTime), SUM(OriginCityMarketID) FROM mytable WHERE ArrDel15 BETWEEN -9999 AND -9999 OR De [...]
+{"sql":"SELECT DestAirportSeqID, DestAirportID, COUNT(ActualElapsedTime) FROM mytable WHERE DestAirportSeqID IN (1387102, 1410702, 1430702, 1104902, 1234302) AND Distance NOT IN (850, 589) GROUP BY DestAirportSeqID, DestAirportID ORDER BY DestAirportSeqID, DestAirportID LIMIT 12","hsqls":["SELECT DestAirportSeqID, DestAirportID, COUNT(ActualElapsedTime) FROM mytable WHERE DestAirportSeqID IN (1387102, 1410702, 1430702, 1104902, 1234302) AND Distance NOT IN (850, 589) GROUP BY DestAirpor [...]
+{"sql":"SELECT DestAirportSeqID, MAX(CarrierDelay), MIN(CarrierDelay), COUNT(TailNum) FROM mytable WHERE OriginCityName < 'Mobile, AL' AND CRSDepTime BETWEEN 1849 AND 949 OR DistanceGroup = 5 GROUP BY DestAirportSeqID ORDER BY DestAirportSeqID LIMIT 5","hsqls":["SELECT DestAirportSeqID, MAX(CarrierDelay), MIN(CarrierDelay), COUNT(TailNum) FROM mytable WHERE OriginCityName < 'Mobile, AL' AND CRSDepTime BETWEEN 1849 AND 949 OR DistanceGroup = 5 GROUP BY DestAirportSeqID ORDER BY DestAirp [...]
+{"sql":"SELECT DestCityMarketID, SUM(DivDistance) FROM mytable WHERE WheelsOff BETWEEN 735 AND 921 GROUP BY DestCityMarketID ORDER BY DestCityMarketID LIMIT 4","hsqls":["SELECT DestCityMarketID, SUM(DivDistance) FROM mytable WHERE WheelsOff BETWEEN 735 AND 921 GROUP BY DestCityMarketID ORDER BY DestCityMarketID LIMIT 4"]}
+{"sql":"SELECT DestCityName, DestCityMarketID, ArrivalDelayGroups, COUNT(*) FROM mytable WHERE DivActualElapsedTime IN (433, 307, 834) GROUP BY DestCityName, DestCityMarketID, ArrivalDelayGroups ORDER BY DestCityName, DestCityMarketID, ArrivalDelayGroups LIMIT 14","hsqls":["SELECT DestCityName, DestCityMarketID, ArrivalDelayGroups, COUNT(*) FROM mytable WHERE DivActualElapsedTime IN (433, 307, 834) GROUP BY DestCityName, DestCityMarketID, ArrivalDelayGroups ORDER BY DestCityName, DestC [...]
+{"sql":"SELECT DestState, ArrTime, COUNT(CancellationCode), AVG(DivAirportLandings) FROM mytable WHERE DestAirportID >= 13424 OR DestAirportSeqID BETWEEN 1062702 AND 1463502 AND CRSArrTime <> 2157 GROUP BY DestState, ArrTime ORDER BY DestState, ArrTime LIMIT 2","hsqls":["SELECT DestState, ArrTime, COUNT(CancellationCode), AVG(DivAirportLandings) FROM mytable WHERE DestAirportID >= 13424 OR DestAirportSeqID BETWEEN 1062702 AND 1463502 AND CRSArrTime <> 2157 GROUP BY DestState, ArrTime O [...]
+{"sql":"SELECT DestState, COUNT(ArrivalDelayGroups) FROM mytable WHERE Dest BETWEEN 'RIC' AND 'CLT' OR OriginStateName <= 'Alaska' OR Dest BETWEEN 'BFL' AND 'MMH' GROUP BY DestState ORDER BY DestState LIMIT 13","hsqls":["SELECT DestState, COUNT(ArrivalDelayGroups) FROM mytable WHERE Dest BETWEEN 'RIC' AND 'CLT' OR OriginStateName <= 'Alaska' OR Dest BETWEEN 'BFL' AND 'MMH' GROUP BY DestState ORDER BY DestState LIMIT 13"]}
+{"sql":"SELECT DestState, CRSDepTime, WheelsOn, MIN(CRSArrTime) FROM mytable WHERE DestStateFips NOT IN (45, 55) AND DivDistance IN (133, 328, 480, 233) GROUP BY DestState, CRSDepTime, WheelsOn ORDER BY DestState, CRSDepTime, WheelsOn LIMIT 10","hsqls":["SELECT DestState, CRSDepTime, WheelsOn, MIN(CRSArrTime) FROM mytable WHERE DestStateFips NOT IN (45, 55) AND DivDistance IN (133, 328, 480, 233) GROUP BY DestState, CRSDepTime, WheelsOn ORDER BY DestState, CRSDepTime, WheelsOn LIMIT 10"]}
+{"sql":"SELECT DestState, LateAircraftDelay, MIN(WheelsOff) FROM mytable WHERE TaxiOut BETWEEN 10 AND 54 OR DepDelay NOT IN (181.0, -4.0) AND OriginAirportSeqID IN (1075402) GROUP BY DestState, LateAircraftDelay ORDER BY DestState, LateAircraftDelay LIMIT 12","hsqls":["SELECT DestState, LateAircraftDelay, MIN(WheelsOff) FROM mytable WHERE TaxiOut BETWEEN 10 AND 54 OR DepDelay NOT IN (181.0, -4.0) AND OriginAirportSeqID IN (1075402) GROUP BY DestState, LateAircraftDelay ORDER BY DestSta [...]
+{"sql":"SELECT DestState, Quarter, NASDelay, COUNT(*) FROM mytable WHERE Cancelled NOT IN (1, 0) OR OriginCityMarketID BETWEEN 30325 AND 35096 AND NASDelay <> 320 GROUP BY DestState, Quarter, NASDelay ORDER BY DestState, Quarter, NASDelay LIMIT 1","hsqls":["SELECT DestState, Quarter, NASDelay, COUNT(*) FROM mytable WHERE Cancelled NOT IN (1, 0) OR OriginCityMarketID BETWEEN 30325 AND 35096 AND NASDelay <> 320 GROUP BY DestState, Quarter, NASDelay ORDER BY DestState, Quarter, NASDelay L [...]
+{"sql":"SELECT DestStateFips, ActualElapsedTime, CRSElapsedTime, COUNT(*) FROM mytable WHERE DepTime >= 1211 GROUP BY DestStateFips, ActualElapsedTime, CRSElapsedTime ORDER BY DestStateFips, ActualElapsedTime, CRSElapsedTime LIMIT 23","hsqls":["SELECT DestStateFips, ActualElapsedTime, CRSElapsedTime, COUNT(*) FROM mytable WHERE DepTime >= 1211 GROUP BY DestStateFips, ActualElapsedTime, CRSElapsedTime ORDER BY DestStateFips, ActualElapsedTime, CRSElapsedTime LIMIT 23"]}
+{"sql":"SELECT DestStateFips, ArrTime, AirTime, MAX(DistanceGroup), COUNT(ArrTime), COUNT(WheelsOff) FROM mytable WHERE DivActualElapsedTime > 331 OR Cancelled NOT IN (1, 0) AND DestAirportSeqID IN (1150303) GROUP BY DestStateFips, ArrTime, AirTime ORDER BY DestStateFips, ArrTime, AirTime LIMIT 10","hsqls":["SELECT DestStateFips, ArrTime, AirTime, MAX(DistanceGroup), COUNT(ArrTime), COUNT(WheelsOff) FROM mytable WHERE DivActualElapsedTime > 331 OR Cancelled NOT IN (1, 0) AND DestAirport [...]
+{"sql":"SELECT DestStateFips, MAX(WheelsOff), COUNT(Cancelled), MIN(Distance) FROM mytable WHERE SecurityDelay IN (4, 18, 8, 27, 14) GROUP BY DestStateFips ORDER BY DestStateFips LIMIT 10","hsqls":["SELECT DestStateFips, MAX(WheelsOff), COUNT(Cancelled), MIN(Distance) FROM mytable WHERE SecurityDelay IN (4, 18, 8, 27, 14) GROUP BY DestStateFips ORDER BY DestStateFips LIMIT 10"]}
+{"sql":"SELECT DestStateName, SUM(LateAircraftDelay), AVG(TaxiIn) FROM mytable WHERE Distance IN (352, 805, 711, 325, 2105) OR ArrDelay BETWEEN 76.0 AND 46.0 GROUP BY DestStateName ORDER BY DestStateName LIMIT 5","hsqls":["SELECT DestStateName, SUM(LateAircraftDelay), AVG(TaxiIn) FROM mytable WHERE Distance IN (352, 805, 711, 325, 2105) OR ArrDelay BETWEEN 76.0 AND 46.0 GROUP BY DestStateName ORDER BY DestStateName LIMIT 5"]}
+{"sql":"SELECT DestWac, Cancelled, AVG(DivReachedDest), AVG(DepDel15), MIN(ActualElapsedTime) FROM mytable WHERE OriginCityName <= 'Nashville, TN' AND DistanceGroup BETWEEN 1 AND 3 AND TotalAddGTime NOT IN (2, 55) GROUP BY DestWac, Cancelled ORDER BY DestWac, Cancelled LIMIT 29","hsqls":["SELECT DestWac, Cancelled, AVG(DivReachedDest), AVG(DepDel15), MIN(ActualElapsedTime) FROM mytable WHERE OriginCityName <= 'Nashville, TN' AND DistanceGroup BETWEEN 1 AND 3 AND TotalAddGTime NOT IN (2, [...]
+{"sql":"SELECT DestWac, FirstDepTime, OriginAirportID, AVG(DayofMonth), MIN(DayofMonth) FROM mytable WHERE DayOfWeek NOT IN (7, 6, 5, 4) GROUP BY DestWac, FirstDepTime, OriginAirportID ORDER BY DestWac, FirstDepTime, OriginAirportID LIMIT 8","hsqls":["SELECT DestWac, FirstDepTime, OriginAirportID, AVG(DayofMonth), MIN(DayofMonth) FROM mytable WHERE DayOfWeek NOT IN (7, 6, 5, 4) GROUP BY DestWac, FirstDepTime, OriginAirportID ORDER BY DestWac, FirstDepTime, OriginAirportID LIMIT 8"]}
+{"sql":"SELECT DestWac, WeatherDelay, DayOfWeek, SUM(Quarter) FROM mytable WHERE Quarter BETWEEN 1 AND 1 GROUP BY DestWac, WeatherDelay, DayOfWeek ORDER BY DestWac, WeatherDelay, DayOfWeek LIMIT 27","hsqls":["SELECT DestWac, WeatherDelay, DayOfWeek, SUM(Quarter) FROM mytable WHERE Quarter BETWEEN 1 AND 1 GROUP BY DestWac, WeatherDelay, DayOfWeek ORDER BY DestWac, WeatherDelay, DayOfWeek LIMIT 27"]}
+{"sql":"SELECT Distance, Dest, OriginStateName, COUNT(*) FROM mytable WHERE DestWac IN (74, 85) OR ArrTimeBlk < '1700-1759' GROUP BY Distance, Dest, OriginStateName ORDER BY Distance, Dest, OriginStateName LIMIT 5","hsqls":["SELECT Distance, Dest, OriginStateName, COUNT(*) FROM mytable WHERE DestWac IN (74, 85) OR ArrTimeBlk < '1700-1759' GROUP BY Distance, Dest, OriginStateName ORDER BY Distance, Dest, OriginStateName LIMIT 5"]}
+{"sql":"SELECT Distance, OriginCityName, COUNT(*) FROM mytable WHERE Carrier IN ('US', 'VX', 'AS') AND LongestAddGTime NOT IN (40, 60) AND DestWac IN (23, 62, 33) GROUP BY Distance, OriginCityName ORDER BY Distance, OriginCityName LIMIT 11","hsqls":["SELECT Distance, OriginCityName, COUNT(*) FROM mytable WHERE Carrier IN ('US', 'VX', 'AS') AND LongestAddGTime NOT IN (40, 60) AND DestWac IN (23, 62, 33) GROUP BY Distance, OriginCityName ORDER BY Distance, OriginCityName LIMIT 11"]}
+{"sql":"SELECT DistanceGroup, AVG(OriginWac), SUM(DepTime) FROM mytable WHERE DivDistance BETWEEN 45 AND 220 GROUP BY DistanceGroup ORDER BY DistanceGroup LIMIT 22","hsqls":["SELECT DistanceGroup, AVG(OriginWac), SUM(DepTime) FROM mytable WHERE DivDistance BETWEEN 45 AND 220 GROUP BY DistanceGroup ORDER BY DistanceGroup LIMIT 22"]}
+{"sql":"SELECT DistanceGroup, DivAirportLandings, COUNT(*) FROM mytable WHERE CRSDepTime NOT IN (1306, 908, 1146, 1038) AND DestAirportID > 12448 AND DivDistance BETWEEN 496 AND 588 GROUP BY DistanceGroup, DivAirportLandings ORDER BY DistanceGroup, DivAirportLandings LIMIT 7","hsqls":["SELECT DistanceGroup, DivAirportLandings, COUNT(*) FROM mytable WHERE CRSDepTime NOT IN (1306, 908, 1146, 1038) AND DestAirportID > 12448 AND DivDistance BETWEEN 496 AND 588 GROUP BY DistanceGroup, DivAir [...]
+{"sql":"SELECT DistanceGroup, TailNum, DaysSinceEpoch, COUNT(OriginCityMarketID), SUM(ArrDelay) FROM mytable WHERE DivDistance > 575 OR DestStateFips IN (49) AND OriginCityMarketID BETWEEN 30849 AND 34108 GROUP BY DistanceGroup, TailNum, DaysSinceEpoch ORDER BY DistanceGroup, TailNum, DaysSinceEpoch LIMIT 2","hsqls":["SELECT DistanceGroup, TailNum, DaysSinceEpoch, COUNT(OriginCityMarketID), SUM(ArrDelay) FROM mytable WHERE DivDistance > 575 OR DestStateFips IN (49) AND OriginCityMarketI [...]
+{"sql":"SELECT DivActualElapsedTime, DayOfWeek, MIN(DestAirportID), COUNT(DivActualElapsedTime), COUNT(DivDistance) FROM mytable WHERE FlightDate IN ('2014-01-20', '2014-01-11', '2014-01-01', '2014-01-08') AND ActualElapsedTime BETWEEN 70 AND 245 AND Carrier <> 'DL' GROUP BY DivActualElapsedTime, DayOfWeek ORDER BY DivActualElapsedTime, DayOfWeek LIMIT 19","hsqls":["SELECT DivActualElapsedTime, DayOfWeek, MIN(DestAirportID), COUNT(DivActualElapsedTime), COUNT(DivDistance) FROM mytable W [...]
+{"sql":"SELECT DivAirportLandings, COUNT(UniqueCarrier) FROM mytable WHERE DivArrDelay BETWEEN 81 AND 120 AND ArrDel15 <> 0 OR DepartureDelayGroups BETWEEN -2 AND 6 GROUP BY DivAirportLandings ORDER BY DivAirportLandings LIMIT 24","hsqls":["SELECT DivAirportLandings, COUNT(UniqueCarrier) FROM mytable WHERE DivArrDelay BETWEEN 81 AND 120 AND ArrDel15 <> 0 OR DepartureDelayGroups BETWEEN -2 AND 6 GROUP BY DivAirportLandings ORDER BY DivAirportLandings LIMIT 24"]}
+{"sql":"SELECT DivArrDelay, ArrivalDelayGroups, MIN(TaxiIn) FROM mytable WHERE ActualElapsedTime = 332 GROUP BY DivArrDelay, ArrivalDelayGroups ORDER BY DivArrDelay, ArrivalDelayGroups LIMIT 26","hsqls":["SELECT DivArrDelay, ArrivalDelayGroups, MIN(TaxiIn) FROM mytable WHERE ActualElapsedTime = 332 GROUP BY DivArrDelay, ArrivalDelayGroups ORDER BY DivArrDelay, ArrivalDelayGroups LIMIT 26"]}
+{"sql":"SELECT DivArrDelay, MAX(DepDelayMinutes), MIN(DestCityMarketID), SUM(Distance) FROM mytable WHERE DepDel15 BETWEEN -9999 AND 1 AND DepTime <> 32 AND FlightDate BETWEEN '2014-01-18' AND '2014-01-21' GROUP BY DivArrDelay ORDER BY DivArrDelay LIMIT 29","hsqls":["SELECT DivArrDelay, MAX(DepDelayMinutes), MIN(DestCityMarketID), SUM(Distance) FROM mytable WHERE DepDel15 BETWEEN -9999 AND 1 AND DepTime <> 32 AND FlightDate BETWEEN '2014-01-18' AND '2014-01-21' GROUP BY DivArrDelay ORD [...]
+{"sql":"SELECT DivDistance, Quarter, DestCityMarketID, AVG(OriginStateFips) FROM mytable WHERE CancellationCode IN ('A', 'B', 'C') GROUP BY DivDistance, Quarter, DestCityMarketID ORDER BY DivDistance, Quarter, DestCityMarketID LIMIT 19","hsqls":["SELECT DivDistance, Quarter, DestCityMarketID, AVG(OriginStateFips) FROM mytable WHERE CancellationCode IN ('A', 'B', 'C') GROUP BY DivDistance, Quarter, DestCityMarketID ORDER BY DivDistance, Quarter, DestCityMarketID LIMIT 19"]}
+{"sql":"SELECT DivReachedDest, COUNT(*) FROM mytable WHERE DestCityMarketID IN (33728, 31205, 30408, 32206) AND OriginStateFips NOT IN (18, 25, 8, 27) GROUP BY DivReachedDest ORDER BY DivReachedDest LIMIT 8","hsqls":["SELECT DivReachedDest, COUNT(*) FROM mytable WHERE DestCityMarketID IN (33728, 31205, 30408, 32206) AND OriginStateFips NOT IN (18, 25, 8, 27) GROUP BY DivReachedDest ORDER BY DivReachedDest LIMIT 8"]}
+{"sql":"SELECT DivReachedDest, Diverted, AVG(ArrDel15) FROM mytable WHERE FlightDate IN ('2014-01-09') GROUP BY DivReachedDest, Diverted ORDER BY DivReachedDest, Diverted LIMIT 5","hsqls":["SELECT DivReachedDest, Diverted, AVG(ArrDel15) FROM mytable WHERE FlightDate IN ('2014-01-09') GROUP BY DivReachedDest, Diverted ORDER BY DivReachedDest, Diverted LIMIT 5"]}
+{"sql":"SELECT DivReachedDest, TaxiIn, SUM(ActualElapsedTime), AVG(ArrivalDelayGroups), MIN(WheelsOff) FROM mytable WHERE DivDistance BETWEEN 391 AND 95 OR ActualElapsedTime BETWEEN 239 AND 413 OR Diverted NOT IN (1, 0) GROUP BY DivReachedDest, TaxiIn ORDER BY DivReachedDest, TaxiIn LIMIT 29","hsqls":["SELECT DivReachedDest, TaxiIn, SUM(ActualElapsedTime), AVG(ArrivalDelayGroups), MIN(WheelsOff) FROM mytable WHERE DivDistance BETWEEN 391 AND 95 OR ActualElapsedTime BETWEEN 239 AND 413 O [...]
+{"sql":"SELECT Diverted, CRSArrTime, CancellationCode, MAX(DaysSinceEpoch), SUM(DayOfWeek), AVG(DivAirportLandings) FROM mytable WHERE ArrTimeBlk < '2300-2359' GROUP BY Diverted, CRSArrTime, CancellationCode ORDER BY Diverted, CRSArrTime, CancellationCode LIMIT 20","hsqls":["SELECT Diverted, CRSArrTime, CancellationCode, MAX(DaysSinceEpoch), SUM(DayOfWeek), AVG(DivAirportLandings) FROM mytable WHERE ArrTimeBlk < '2300-2359' GROUP BY Diverted, CRSArrTime, CancellationCode ORDER BY Diver [...]
+{"sql":"SELECT Diverted, DestStateName, COUNT(*) FROM mytable WHERE LongestAddGTime NOT IN (58, 63) OR NASDelay NOT IN (146, 109) AND TailNum <> 'N944AT' GROUP BY Diverted, DestStateName ORDER BY Diverted, DestStateName LIMIT 21","hsqls":["SELECT Diverted, DestStateName, COUNT(*) FROM mytable WHERE LongestAddGTime NOT IN (58, 63) OR NASDelay NOT IN (146, 109) AND TailNum <> 'N944AT' GROUP BY Diverted, DestStateName ORDER BY Diverted, DestStateName LIMIT 21"]}
+{"sql":"SELECT Diverted, SUM(NASDelay), SUM(FirstDepTime), COUNT(CRSDepTime) FROM mytable WHERE Cancelled NOT IN (1) OR Distance IN (764, 301, 715, 945) GROUP BY Diverted ORDER BY Diverted LIMIT 19","hsqls":["SELECT Diverted, SUM(NASDelay), SUM(FirstDepTime), COUNT(CRSDepTime) FROM mytable WHERE Cancelled NOT IN (1) OR Distance IN (764, 301, 715, 945) GROUP BY Diverted ORDER BY Diverted LIMIT 19"]}
+{"sql":"SELECT FirstDepTime, DestAirportID, DayOfWeek, COUNT(*) FROM mytable WHERE CRSDepTime <> 2350 GROUP BY FirstDepTime, DestAirportID, DayOfWeek ORDER BY FirstDepTime, DestAirportID, DayOfWeek LIMIT 29","hsqls":["SELECT FirstDepTime, DestAirportID, DayOfWeek, COUNT(*) FROM mytable WHERE CRSDepTime <> 2350 GROUP BY FirstDepTime, DestAirportID, DayOfWeek ORDER BY FirstDepTime, DestAirportID, DayOfWeek LIMIT 29"]}
+{"sql":"SELECT FirstDepTime, MIN(DivActualElapsedTime), MAX(DistanceGroup), MAX(ArrDelayMinutes) FROM mytable WHERE AirTime <= 200 OR Diverted > 1 OR CRSDepTime BETWEEN 612 AND 1653 GROUP BY FirstDepTime ORDER BY FirstDepTime LIMIT 29","hsqls":["SELECT FirstDepTime, MIN(DivActualElapsedTime), MAX(DistanceGroup), MAX(ArrDelayMinutes) FROM mytable WHERE AirTime <= 200 OR Diverted > 1 OR CRSDepTime BETWEEN 612 AND 1653 GROUP BY FirstDepTime ORDER BY FirstDepTime LIMIT 29"]}
+{"sql":"SELECT FlightDate, ArrDelay, SUM(Diverted), SUM(FlightNum), MIN(OriginCityMarketID) FROM mytable WHERE OriginState BETWEEN 'NV' AND 'VI' GROUP BY FlightDate, ArrDelay ORDER BY FlightDate, ArrDelay LIMIT 17","hsqls":["SELECT FlightDate, ArrDelay, SUM(Diverted), SUM(FlightNum), MIN(OriginCityMarketID) FROM mytable WHERE OriginState BETWEEN 'NV' AND 'VI' GROUP BY FlightDate, ArrDelay ORDER BY FlightDate, ArrDelay LIMIT 17"]}
+{"sql":"SELECT FlightDate, OriginCityName, DestAirportID, MAX(Quarter) FROM mytable WHERE DestCityMarketID IN (30732, 34520, 31295, 30599) OR DepDelayMinutes IN (334.0) GROUP BY FlightDate, OriginCityName, DestAirportID ORDER BY FlightDate, OriginCityName, DestAirportID LIMIT 10","hsqls":["SELECT FlightDate, OriginCityName, DestAirportID, MAX(Quarter) FROM mytable WHERE DestCityMarketID IN (30732, 34520, 31295, 30599) OR DepDelayMinutes IN (334.0) GROUP BY FlightDate, OriginCityName, De [...]
+{"sql":"SELECT FlightNum, CRSArrTime, OriginAirportID, MAX(DepTime), SUM(DestAirportSeqID) FROM mytable WHERE CRSElapsedTime = 166 AND OriginCityMarketID <> 34108 GROUP BY FlightNum, CRSArrTime, OriginAirportID ORDER BY FlightNum, CRSArrTime, OriginAirportID LIMIT 13","hsqls":["SELECT FlightNum, CRSArrTime, OriginAirportID, MAX(DepTime), SUM(DestAirportSeqID) FROM mytable WHERE CRSElapsedTime = 166 AND OriginCityMarketID <> 34108 GROUP BY FlightNum, CRSArrTime, OriginAirportID ORDER BY [...]
+{"sql":"SELECT FlightNum, DivAirportLandings, ArrivalDelayGroups, MIN(DestCityMarketID), COUNT(DivArrDelay) FROM mytable WHERE LateAircraftDelay BETWEEN 105 AND 129 GROUP BY FlightNum, DivAirportLandings, ArrivalDelayGroups ORDER BY FlightNum, DivAirportLandings, ArrivalDelayGroups LIMIT 13","hsqls":["SELECT FlightNum, DivAirportLandings, ArrivalDelayGroups, MIN(DestCityMarketID), COUNT(DivArrDelay) FROM mytable WHERE LateAircraftDelay BETWEEN 105 AND 129 GROUP BY FlightNum, DivAirportL [...]
+{"sql":"SELECT LateAircraftDelay, ArrDel15, AVG(DestStateFips), MAX(DayofMonth) FROM mytable WHERE ArrivalDelayGroups IN (10, -9999) OR WheelsOn NOT IN (1133, 1903, 1855) GROUP BY LateAircraftDelay, ArrDel15 ORDER BY LateAircraftDelay, ArrDel15 LIMIT 2","hsqls":["SELECT LateAircraftDelay, ArrDel15, AVG(DestStateFips), MAX(DayofMonth) FROM mytable WHERE ArrivalDelayGroups IN (10, -9999) OR WheelsOn NOT IN (1133, 1903, 1855) GROUP BY LateAircraftDelay, ArrDel15 ORDER BY LateAircraftDelay [...]
+{"sql":"SELECT LateAircraftDelay, FlightDate, TailNum, COUNT(DayOfWeek) FROM mytable WHERE DepDel15 IN (1, 0, -9999) GROUP BY LateAircraftDelay, FlightDate, TailNum ORDER BY LateAircraftDelay, FlightDate, TailNum LIMIT 19","hsqls":["SELECT LateAircraftDelay, FlightDate, TailNum, COUNT(DayOfWeek) FROM mytable WHERE DepDel15 IN (1, 0, -9999) GROUP BY LateAircraftDelay, FlightDate, TailNum ORDER BY LateAircraftDelay, FlightDate, TailNum LIMIT 19"]}
+{"sql":"SELECT LongestAddGTime, ArrivalDelayGroups, OriginAirportID, COUNT(*) FROM mytable WHERE DivArrDelay <= 638 GROUP BY LongestAddGTime, ArrivalDelayGroups, OriginAirportID ORDER BY LongestAddGTime, ArrivalDelayGroups, OriginAirportID LIMIT 7","hsqls":["SELECT LongestAddGTime, ArrivalDelayGroups, OriginAirportID, COUNT(*) FROM mytable WHERE DivArrDelay <= 638 GROUP BY LongestAddGTime, ArrivalDelayGroups, OriginAirportID ORDER BY LongestAddGTime, ArrivalDelayGroups, OriginAirportID [...]
+{"sql":"SELECT LongestAddGTime, MAX(AirlineID), SUM(CRSArrTime), SUM(DivArrDelay) FROM mytable WHERE FirstDepTime BETWEEN 12 AND 617 OR LongestAddGTime <> 55 OR CRSArrTime <> 846 GROUP BY LongestAddGTime ORDER BY LongestAddGTime LIMIT 28","hsqls":["SELECT LongestAddGTime, MAX(AirlineID), SUM(CRSArrTime), SUM(DivArrDelay) FROM mytable WHERE FirstDepTime BETWEEN 12 AND 617 OR LongestAddGTime <> 55 OR CRSArrTime <> 846 GROUP BY LongestAddGTime ORDER BY LongestAddGTime LIMIT 28"]}
+{"sql":"SELECT NASDelay, MAX(Flights), SUM(DepartureDelayGroups) FROM mytable WHERE DestState BETWEEN 'CT' AND 'HI' AND ArrDelayMinutes IN (155.0, 218.0, 343.0) AND DivArrDelay <> 167 GROUP BY NASDelay ORDER BY NASDelay LIMIT 13","hsqls":["SELECT NASDelay, MAX(Flights), SUM(DepartureDelayGroups) FROM mytable WHERE DestState BETWEEN 'CT' AND 'HI' AND ArrDelayMinutes IN (155.0, 218.0, 343.0) AND DivArrDelay <> 167 GROUP BY NASDelay ORDER BY NASDelay LIMIT 13"]}
+{"sql":"SELECT Origin, DaysSinceEpoch, COUNT(FirstDepTime), MIN(TaxiIn) FROM mytable WHERE WheelsOn > 1807 GROUP BY Origin, DaysSinceEpoch ORDER BY Origin, DaysSinceEpoch LIMIT 2","hsqls":["SELECT Origin, DaysSinceEpoch, COUNT(FirstDepTime), MIN(TaxiIn) FROM mytable WHERE WheelsOn > 1807 GROUP BY Origin, DaysSinceEpoch ORDER BY Origin, DaysSinceEpoch LIMIT 2"]}
+{"sql":"SELECT OriginAirportID, SUM(CRSArrTime), MAX(CRSDepTime), MAX(Cancelled) FROM mytable WHERE DepDelay IN (270.0) OR OriginCityMarketID BETWEEN 32389 AND 32511 OR CRSDepTime BETWEEN 1028 AND 1408 GROUP BY OriginAirportID ORDER BY OriginAirportID LIMIT 27","hsqls":["SELECT OriginAirportID, SUM(CRSArrTime), MAX(CRSDepTime), MAX(Cancelled) FROM mytable WHERE DepDelay IN (270.0) OR OriginCityMarketID BETWEEN 32389 AND 32511 OR CRSDepTime BETWEEN 1028 AND 1408 GROUP BY OriginAirportID [...]
+{"sql":"SELECT OriginAirportSeqID, DepDel15, AirlineID, AVG(Diverted) FROM mytable WHERE Diverted IN (1, 0) AND UniqueCarrier BETWEEN 'VX' AND 'DL' OR LongestAddGTime > 7 GROUP BY OriginAirportSeqID, DepDel15, AirlineID ORDER BY OriginAirportSeqID, DepDel15, AirlineID LIMIT 29","hsqls":["SELECT OriginAirportSeqID, DepDel15, AirlineID, AVG(Diverted) FROM mytable WHERE Diverted IN (1, 0) AND UniqueCarrier BETWEEN 'VX' AND 'DL' OR LongestAddGTime > 7 GROUP BY OriginAirportSeqID, DepDel15, [...]
+{"sql":"SELECT OriginAirportSeqID, LongestAddGTime, ArrTimeBlk, SUM(CRSDepTime), AVG(TaxiIn), AVG(WheelsOff) FROM mytable WHERE LongestAddGTime < 37 GROUP BY OriginAirportSeqID, LongestAddGTime, ArrTimeBlk ORDER BY OriginAirportSeqID, LongestAddGTime, ArrTimeBlk LIMIT 6","hsqls":["SELECT OriginAirportSeqID, LongestAddGTime, ArrTimeBlk, SUM(CRSDepTime), AVG(TaxiIn), AVG(WheelsOff) FROM mytable WHERE LongestAddGTime < 37 GROUP BY OriginAirportSeqID, LongestAddGTime, ArrTimeBlk ORDER BY O [...]
+{"sql":"SELECT OriginCityMarketID, CRSElapsedTime, DaysSinceEpoch, SUM(CRSElapsedTime) FROM mytable WHERE Cancelled <= 1 OR ArrDelay NOT IN (245.0, 193.0, 450.0) AND Distance > 1156 GROUP BY OriginCityMarketID, CRSElapsedTime, DaysSinceEpoch ORDER BY OriginCityMarketID, CRSElapsedTime, DaysSinceEpoch LIMIT 26","hsqls":["SELECT OriginCityMarketID, CRSElapsedTime, DaysSinceEpoch, SUM(CRSElapsedTime) FROM mytable WHERE Cancelled <= 1 OR ArrDelay NOT IN (245.0, 193.0, 450.0) AND Distance > [...]
+{"sql":"SELECT OriginCityMarketID, OriginCityName, DepDel15, COUNT(ArrDel15) FROM mytable WHERE CRSDepTime <> 2034 AND ArrDelay NOT IN (-40.0, 132.0) GROUP BY OriginCityMarketID, OriginCityName, DepDel15 ORDER BY OriginCityMarketID, OriginCityName, DepDel15 LIMIT 6","hsqls":["SELECT OriginCityMarketID, OriginCityName, DepDel15, COUNT(ArrDel15) FROM mytable WHERE CRSDepTime <> 2034 AND ArrDelay NOT IN (-40.0, 132.0) GROUP BY OriginCityMarketID, OriginCityName, DepDel15 ORDER BY OriginCi [...]
+{"sql":"SELECT OriginCityMarketID, OriginCityName, DivArrDelay, MIN(OriginWac), SUM(DayOfWeek), COUNT(AirlineID) FROM mytable WHERE DepartureDelayGroups IN (10, 0, 5) AND FlightDate <> '2014-01-03' GROUP BY OriginCityMarketID, OriginCityName, DivArrDelay ORDER BY OriginCityMarketID, OriginCityName, DivArrDelay LIMIT 6","hsqls":["SELECT OriginCityMarketID, OriginCityName, DivArrDelay, MIN(OriginWac), SUM(DayOfWeek), COUNT(AirlineID) FROM mytable WHERE DepartureDelayGroups IN (10, 0, 5) A [...]
+{"sql":"SELECT OriginCityName, DepTime, UniqueCarrier, COUNT(*) FROM mytable WHERE ArrivalDelayGroups BETWEEN 5 AND 7 GROUP BY OriginCityName, DepTime, UniqueCarrier ORDER BY OriginCityName, DepTime, UniqueCarrier LIMIT 19","hsqls":["SELECT OriginCityName, DepTime, UniqueCarrier, COUNT(*) FROM mytable WHERE ArrivalDelayGroups BETWEEN 5 AND 7 GROUP BY OriginCityName, DepTime, UniqueCarrier ORDER BY OriginCityName, DepTime, UniqueCarrier LIMIT 19"]}
+{"sql":"SELECT OriginCityName, MAX(TotalAddGTime), MIN(DistanceGroup) FROM mytable WHERE Dest NOT IN ('MSN') OR FirstDepTime <= 1859 OR Distance = 422 GROUP BY OriginCityName ORDER BY OriginCityName LIMIT 1","hsqls":["SELECT OriginCityName, MAX(TotalAddGTime), MIN(DistanceGroup) FROM mytable WHERE Dest NOT IN ('MSN') OR FirstDepTime <= 1859 OR Distance = 422 GROUP BY OriginCityName ORDER BY OriginCityName LIMIT 1"]}
+{"sql":"SELECT OriginState, DepDel15, MAX(SecurityDelay), AVG(SecurityDelay), MIN(LongestAddGTime) FROM mytable WHERE DepartureDelayGroups >= 11 GROUP BY OriginState, DepDel15 ORDER BY OriginState, DepDel15 LIMIT 14","hsqls":["SELECT OriginState, DepDel15, MAX(SecurityDelay), AVG(SecurityDelay), MIN(LongestAddGTime) FROM mytable WHERE DepartureDelayGroups >= 11 GROUP BY OriginState, DepDel15 ORDER BY OriginState, DepDel15 LIMIT 14"]}
+{"sql":"SELECT OriginState, DepTime, COUNT(*) FROM mytable WHERE Origin < 'LAW' AND ArrivalDelayGroups <> 11 OR DayofMonth BETWEEN 30 AND 15 GROUP BY OriginState, DepTime ORDER BY OriginState, DepTime LIMIT 22","hsqls":["SELECT OriginState, DepTime, COUNT(*) FROM mytable WHERE Origin < 'LAW' AND ArrivalDelayGroups <> 11 OR DayofMonth BETWEEN 30 AND 15 GROUP BY OriginState, DepTime ORDER BY OriginState, DepTime LIMIT 22"]}
+{"sql":"SELECT OriginState, MAX(DivArrDelay), MIN(CRSArrTime) FROM mytable WHERE OriginCityName <> 'Louisville, KY' OR CRSDepTime IN (1247, 2305, 936) OR OriginAirportSeqID <= 1152502 GROUP BY OriginState ORDER BY OriginState LIMIT 1","hsqls":["SELECT OriginState, MAX(DivArrDelay), MIN(CRSArrTime) FROM mytable WHERE OriginCityName <> 'Louisville, KY' OR CRSDepTime IN (1247, 2305, 936) OR OriginAirportSeqID <= 1152502 GROUP BY OriginState ORDER BY OriginState LIMIT 1"]}
+{"sql":"SELECT OriginState, MAX(LateAircraftDelay), MAX(DayOfWeek) FROM mytable WHERE CarrierDelay BETWEEN 0 AND 243 GROUP BY OriginState ORDER BY OriginState LIMIT 8","hsqls":["SELECT OriginState, MAX(LateAircraftDelay), MAX(DayOfWeek) FROM mytable WHERE CarrierDelay BETWEEN 0 AND 243 GROUP BY OriginState ORDER BY OriginState LIMIT 8"]}
+{"sql":"SELECT OriginStateFips, DepDelayMinutes, COUNT(DepDelayMinutes) FROM mytable WHERE OriginAirportSeqID IN (1106702) GROUP BY OriginStateFips, DepDelayMinutes ORDER BY OriginStateFips, DepDelayMinutes LIMIT 15","hsqls":["SELECT OriginStateFips, DepDelayMinutes, COUNT(DepDelayMinutes) FROM mytable WHERE OriginAirportSeqID IN (1106702) GROUP BY OriginStateFips, DepDelayMinutes ORDER BY OriginStateFips, DepDelayMinutes LIMIT 15"]}
+{"sql":"SELECT OriginStateFips, MAX(OriginAirportID), AVG(AirlineID) FROM mytable WHERE OriginWac IN (52, 86) OR OriginAirportID >= 10792 GROUP BY OriginStateFips ORDER BY OriginStateFips LIMIT 18","hsqls":["SELECT OriginStateFips, MAX(OriginAirportID), AVG(AirlineID) FROM mytable WHERE OriginWac IN (52, 86) OR OriginAirportID >= 10792 GROUP BY OriginStateFips ORDER BY OriginStateFips LIMIT 18"]}
+{"sql":"SELECT OriginStateName, SUM(ActualElapsedTime), MIN(DestCityMarketID), AVG(DivActualElapsedTime) FROM mytable WHERE DestAirportID BETWEEN 10643 AND 13232 GROUP BY OriginStateName ORDER BY OriginStateName LIMIT 16","hsqls":["SELECT OriginStateName, SUM(ActualElapsedTime), MIN(DestCityMarketID), AVG(DivActualElapsedTime) FROM mytable WHERE DestAirportID BETWEEN 10643 AND 13232 GROUP BY OriginStateName ORDER BY OriginStateName LIMIT 16"]}
+{"sql":"SELECT Quarter, ArrDelayMinutes, AVG(WeatherDelay) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR LateAircraftDelay NOT IN (159) GROUP BY Quarter, ArrDelayMinutes ORDER BY Quarter, ArrDelayMinutes LIMIT 12","hsqls":["SELECT Quarter, ArrDelayMinutes, AVG(WeatherDelay) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR LateAircraftDelay NOT IN (159) GROUP BY Quarter, ArrDelayMinutes ORDER BY Quarter, ArrDelayMinutes LIMIT 12"]}
+{"sql":"SELECT Quarter, CRSElapsedTime, DayOfWeek, AVG(TaxiOut), MIN(DepDel15), MIN(CRSElapsedTime) FROM mytable WHERE OriginWac NOT IN (93, 81) AND OriginAirportID = 10434 OR DestState > 'PA' GROUP BY Quarter, CRSElapsedTime, DayOfWeek ORDER BY Quarter, CRSElapsedTime, DayOfWeek LIMIT 18","hsqls":["SELECT Quarter, CRSElapsedTime, DayOfWeek, AVG(TaxiOut), MIN(DepDel15), MIN(CRSElapsedTime) FROM mytable WHERE OriginWac NOT IN (93, 81) AND OriginAirportID = 10434 OR DestState > 'PA' GROUP [...]
+{"sql":"SELECT SecurityDelay, CancellationCode, OriginAirportID, COUNT(*) FROM mytable WHERE ArrTime = 1134 OR FlightNum < 2858 OR DivArrDelay BETWEEN 187 AND 346 GROUP BY SecurityDelay, CancellationCode, OriginAirportID ORDER BY SecurityDelay, CancellationCode, OriginAirportID LIMIT 28","hsqls":["SELECT SecurityDelay, CancellationCode, OriginAirportID, COUNT(*) FROM mytable WHERE ArrTime = 1134 OR FlightNum < 2858 OR DivArrDelay BETWEEN 187 AND 346 GROUP BY SecurityDelay, CancellationC [...]
+{"sql":"SELECT TailNum, AirTime, COUNT(*) FROM mytable WHERE Dest <> 'CRW' OR DepDel15 = -9999 AND DestCityName IN ('Butte, MT') GROUP BY TailNum, AirTime ORDER BY TailNum, AirTime LIMIT 26","hsqls":["SELECT TailNum, AirTime, COUNT(*) FROM mytable WHERE Dest <> 'CRW' OR DepDel15 = -9999 AND DestCityName IN ('Butte, MT') GROUP BY TailNum, AirTime ORDER BY TailNum, AirTime LIMIT 26"]}
+{"sql":"SELECT TailNum, OriginWac, DayOfWeek, MAX(WheelsOff), SUM(CRSArrTime), MAX(TaxiIn) FROM mytable WHERE OriginWac NOT IN (45, 93, 23, 86) GROUP BY TailNum, OriginWac, DayOfWeek ORDER BY TailNum, OriginWac, DayOfWeek LIMIT 28","hsqls":["SELECT TailNum, OriginWac, DayOfWeek, MAX(WheelsOff), SUM(CRSArrTime), MAX(TaxiIn) FROM mytable WHERE OriginWac NOT IN (45, 93, 23, 86) GROUP BY TailNum, OriginWac, DayOfWeek ORDER BY TailNum, OriginWac, DayOfWeek LIMIT 28"]}
+{"sql":"SELECT TaxiIn, MIN(DepartureDelayGroups), MAX(CRSDepTime) FROM mytable WHERE DestWac <> 82 AND DaysSinceEpoch BETWEEN 16087 AND 16099 OR ArrTime = 314 GROUP BY TaxiIn ORDER BY TaxiIn LIMIT 29","hsqls":["SELECT TaxiIn, MIN(DepartureDelayGroups), MAX(CRSDepTime) FROM mytable WHERE DestWac <> 82 AND DaysSinceEpoch BETWEEN 16087 AND 16099 OR ArrTime = 314 GROUP BY TaxiIn ORDER BY TaxiIn LIMIT 29"]}
+{"sql":"SELECT TaxiOut, DayofMonth, COUNT(*) FROM mytable WHERE OriginCityMarketID < 30141 AND AirlineID BETWEEN 20398 AND 20437 GROUP BY TaxiOut, DayofMonth ORDER BY TaxiOut, DayofMonth LIMIT 29","hsqls":["SELECT TaxiOut, DayofMonth, COUNT(*) FROM mytable WHERE OriginCityMarketID < 30141 AND AirlineID BETWEEN 20398 AND 20437 GROUP BY TaxiOut, DayofMonth ORDER BY TaxiOut, DayofMonth LIMIT 29"]}
+{"sql":"SELECT TaxiOut, FirstDepTime, NASDelay, AVG(DivDistance), COUNT(Cancelled), SUM(DivDistance) FROM mytable WHERE ArrTime NOT IN (850, 1726, 836) GROUP BY TaxiOut, FirstDepTime, NASDelay ORDER BY TaxiOut, FirstDepTime, NASDelay LIMIT 18","hsqls":["SELECT TaxiOut, FirstDepTime, NASDelay, AVG(DivDistance), COUNT(Cancelled), SUM(DivDistance) FROM mytable WHERE ArrTime NOT IN (850, 1726, 836) GROUP BY TaxiOut, FirstDepTime, NASDelay ORDER BY TaxiOut, FirstDepTime, NASDelay LIMIT 18"]}
+{"sql":"SELECT TaxiOut, WheelsOn, AVG(DaysSinceEpoch), MAX(TaxiIn), AVG(DistanceGroup) FROM mytable WHERE NASDelay IN (78) OR DepTimeBlk BETWEEN '2100-2159' AND '1700-1759' GROUP BY TaxiOut, WheelsOn ORDER BY TaxiOut, WheelsOn LIMIT 7","hsqls":["SELECT TaxiOut, WheelsOn, AVG(DaysSinceEpoch), MAX(TaxiIn), AVG(DistanceGroup) FROM mytable WHERE NASDelay IN (78) OR DepTimeBlk BETWEEN '2100-2159' AND '1700-1759' GROUP BY TaxiOut, WheelsOn ORDER BY TaxiOut, WheelsOn LIMIT 7"]}
+{"sql":"SELECT TotalAddGTime, ArrivalDelayGroups, OriginStateName, MAX(WheelsOff), SUM(FirstDepTime), MAX(DayOfWeek) FROM mytable WHERE FlightDate < '2014-01-28' OR WheelsOn > 1218 OR TaxiIn NOT IN (116, 67, 31, 36) GROUP BY TotalAddGTime, ArrivalDelayGroups, OriginStateName ORDER BY TotalAddGTime, ArrivalDelayGroups, OriginStateName LIMIT 14","hsqls":["SELECT TotalAddGTime, ArrivalDelayGroups, OriginStateName, MAX(WheelsOff), SUM(FirstDepTime), MAX(DayOfWeek) FROM mytable WHERE FlightD [...]
+{"sql":"SELECT TotalAddGTime, DepDel15, Origin, COUNT(*) FROM mytable WHERE DistanceGroup BETWEEN 3 AND 10 OR FlightNum > 4146 OR DistanceGroup BETWEEN 7 AND 2 GROUP BY TotalAddGTime, DepDel15, Origin ORDER BY TotalAddGTime, DepDel15, Origin LIMIT 12","hsqls":["SELECT TotalAddGTime, DepDel15, Origin, COUNT(*) FROM mytable WHERE DistanceGroup BETWEEN 3 AND 10 OR FlightNum > 4146 OR DistanceGroup BETWEEN 7 AND 2 GROUP BY TotalAddGTime, DepDel15, Origin ORDER BY TotalAddGTime, DepDel15, O [...]
+{"sql":"SELECT UniqueCarrier, MIN(DepDelayMinutes), AVG(DestWac) FROM mytable WHERE UniqueCarrier BETWEEN 'OO' AND 'FL' OR SecurityDelay IN (0, 18) GROUP BY UniqueCarrier ORDER BY UniqueCarrier LIMIT 17","hsqls":["SELECT UniqueCarrier, MIN(DepDelayMinutes), AVG(DestWac) FROM mytable WHERE UniqueCarrier BETWEEN 'OO' AND 'FL' OR SecurityDelay IN (0, 18) GROUP BY UniqueCarrier ORDER BY UniqueCarrier LIMIT 17"]}
+{"sql":"SELECT WeatherDelay, DivActualElapsedTime, MAX(LateAircraftDelay) FROM mytable WHERE CarrierDelay IN (3, 117, 59, 102, 11) OR Carrier >= 'DL' GROUP BY WeatherDelay, DivActualElapsedTime ORDER BY WeatherDelay, DivActualElapsedTime LIMIT 11","hsqls":["SELECT WeatherDelay, DivActualElapsedTime, MAX(LateAircraftDelay) FROM mytable WHERE CarrierDelay IN (3, 117, 59, 102, 11) OR Carrier >= 'DL' GROUP BY WeatherDelay, DivActualElapsedTime ORDER BY WeatherDelay, DivActualElapsedTime LI [...]
+{"sql":"SELECT WheelsOff, CRSArrTime, OriginCityMarketID, MAX(DestAirportSeqID), MIN(CRSElapsedTime), SUM(OriginAirportSeqID) FROM mytable WHERE DayOfWeek BETWEEN 2 AND 7 GROUP BY WheelsOff, CRSArrTime, OriginCityMarketID ORDER BY WheelsOff, CRSArrTime, OriginCityMarketID LIMIT 8","hsqls":["SELECT WheelsOff, CRSArrTime, OriginCityMarketID, MAX(DestAirportSeqID), MIN(CRSElapsedTime), SUM(OriginAirportSeqID) FROM mytable WHERE DayOfWeek BETWEEN 2 AND 7 GROUP BY WheelsOff, CRSArrTime, Orig [...]
+{"sql":"SELECT WheelsOff, DistanceGroup, OriginAirportID, SUM(OriginAirportSeqID), MAX(LateAircraftDelay), MAX(Diverted) FROM mytable WHERE TaxiOut <> 45 GROUP BY WheelsOff, DistanceGroup, OriginAirportID ORDER BY WheelsOff, DistanceGroup, OriginAirportID LIMIT 6","hsqls":["SELECT WheelsOff, DistanceGroup, OriginAirportID, SUM(OriginAirportSeqID), MAX(LateAircraftDelay), MAX(Diverted) FROM mytable WHERE TaxiOut <> 45 GROUP BY WheelsOff, DistanceGroup, OriginAirportID ORDER BY WheelsOff [...]
+{"sql":"SELECT WheelsOn, AVG(CRSArrTime), COUNT(Distance) FROM mytable WHERE WheelsOn > 1550 GROUP BY WheelsOn ORDER BY WheelsOn LIMIT 21","hsqls":["SELECT WheelsOn, AVG(CRSArrTime), COUNT(Distance) FROM mytable WHERE WheelsOn > 1550 GROUP BY WheelsOn ORDER BY WheelsOn LIMIT 21"]}
+{"sql":"SELECT WheelsOn, MIN(OriginStateFips), AVG(DivArrDelay), MAX(ActualElapsedTime) FROM mytable WHERE DestStateName BETWEEN 'Alabama' AND 'Rhode Island' AND DayofMonth BETWEEN 24 AND 25 OR WheelsOn BETWEEN 1823 AND 1723 GROUP BY WheelsOn ORDER BY WheelsOn LIMIT 29","hsqls":["SELECT WheelsOn, MIN(OriginStateFips), AVG(DivArrDelay), MAX(ActualElapsedTime) FROM mytable WHERE DestStateName BETWEEN 'Alabama' AND 'Rhode Island' AND DayofMonth BETWEEN 24 AND 25 OR WheelsOn BETWEEN 1823 AN [...]
+
+# Selection
+# {"sql":"SELECT DestCityName, DepDel15 FROM mytable WHERE LongestAddGTime > 97 ORDER BY DestCityName"}
+
+{"sql":"SELECT ActualElapsedTime, ActualElapsedTime, DestCityName FROM mytable ORDER BY ActualElapsedTime, DestCityName LIMIT 25"}
+{"sql":"SELECT ActualElapsedTime, TaxiOut, SecurityDelay, DestCityMarketID FROM mytable WHERE \"Month\" IN (1) OR OriginStateName BETWEEN 'Connecticut' AND 'Pennsylvania' OR ArrTime < 2123 ORDER BY TaxiOut, SecurityDelay, DestCityMarketID LIMIT 11","hsqls":["SELECT ActualElapsedTime, TaxiOut, SecurityDelay, DestCityMarketID FROM mytable WHERE Month IN (1) OR OriginStateName BETWEEN 'Connecticut' AND 'Pennsylvania' OR ArrTime < 2123 ORDER BY TaxiOut, SecurityDelay, DestCityMarketID LIMIT 11"]}
+{"sql":"SELECT AirTime, OriginWac, CRSElapsedTime FROM mytable WHERE TotalAddGTime <= 21 ORDER BY OriginWac, CRSElapsedTime LIMIT 16"}
+{"sql":"SELECT AirlineID, OriginAirportSeqID, FlightDate FROM mytable WHERE WeatherDelay BETWEEN 234 AND 1 AND ArrDel15 BETWEEN -9999 AND 1 OR ArrivalDelayGroups > 7 ORDER BY OriginAirportSeqID, FlightDate LIMIT 28"}
+{"sql":"SELECT ArrDel15, DayofMonth FROM mytable WHERE CRSArrTime >= 711 OR Flights IN (1) ORDER BY DayofMonth LIMIT 1"}
+{"sql":"SELECT ArrDelay, WheelsOff, DayOfWeek FROM mytable ORDER BY WheelsOff, DayOfWeek LIMIT 26"}
+{"sql":"SELECT ArrDelayMinutes, OriginStateFips, DayOfWeek FROM mytable WHERE AirlineID NOT IN (19393, 20437, 20409) AND FlightNum BETWEEN 5601 AND 6260 OR Diverted IN (1, 0) ORDER BY OriginStateFips, DayOfWeek LIMIT 22"}
+{"sql":"SELECT ArrTime, FlightNum, NASDelay FROM mytable WHERE ArrivalDelayGroups = -2 OR DayOfWeek BETWEEN 1 AND 7 ORDER BY FlightNum, NASDelay LIMIT 24"}
+{"sql":"SELECT ArrTimeBlk, NASDelay, DayofMonth, OriginWac FROM mytable ORDER BY NASDelay, DayofMonth, OriginWac LIMIT 27"}
+{"sql":"SELECT ArrivalDelayGroups, TotalAddGTime, TailNum, DivArrDelay FROM mytable WHERE DepartureDelayGroups BETWEEN 1 AND -1 ORDER BY TotalAddGTime, TailNum, DivArrDelay LIMIT 18"}
+{"sql":"SELECT CRSArrTime, DepTimeBlk FROM mytable WHERE ArrDel15 BETWEEN 0 AND 0 OR DivActualElapsedTime IN (989, 387, 847) AND Quarter < 1 ORDER BY DepTimeBlk LIMIT 12"}
+{"sql":"SELECT CRSDepTime, ArrTimeBlk FROM mytable WHERE ArrivalDelayGroups BETWEEN 11 AND 6 OR CRSDepTime >= 1207 ORDER BY ArrTimeBlk LIMIT 18"}
+{"sql":"SELECT CRSElapsedTime, DaysSinceEpoch, \"Year\", LateAircraftDelay FROM mytable WHERE DepartureDelayGroups IN (2, 5) ORDER BY \"Year\", LateAircraftDelay LIMIT 11","hsqls":["SELECT CRSElapsedTime, DaysSinceEpoch, Year, LateAircraftDelay FROM mytable WHERE DepartureDelayGroups IN (2, 5) ORDER BY Year, LateAircraftDelay LIMIT 11"]}
+{"sql":"SELECT CancellationCode, Flights FROM mytable WHERE OriginState IN ('DE', 'KY', 'SC') OR TaxiIn IN (79, 48, 44, 39) ORDER BY Flights LIMIT 19"}
+{"sql":"SELECT Carrier, OriginCityMarketID, DestCityName, Origin FROM mytable ORDER BY OriginCityMarketID, DestCityName, Origin LIMIT 2"}
+{"sql":"SELECT CarrierDelay, \"Year\", DestState, DaysSinceEpoch FROM mytable ORDER BY \"Year\", DestState, DaysSinceEpoch LIMIT 16","hsqls":["SELECT CarrierDelay, Year, DestState, DaysSinceEpoch FROM mytable ORDER BY Year, DestState, DaysSinceEpoch LIMIT 16"]}
+{"sql":"SELECT DayOfWeek, DepartureDelayGroups, CRSArrTime FROM mytable WHERE Cancelled < 1 OR Origin = 'COD' AND OriginCityName NOT IN ('Dallas, TX') ORDER BY DepartureDelayGroups, CRSArrTime LIMIT 19"}
+{"sql":"SELECT DaysSinceEpoch, Quarter FROM mytable WHERE Distance BETWEEN 919 AND 1623 OR OriginCityMarketID NOT IN (33851, 30713, 32511) OR CRSArrTime = 1000 ORDER BY Quarter LIMIT 7"}
+{"sql":"SELECT DepDelay, TaxiIn, ArrivalDelayGroups FROM mytable WHERE ArrTimeBlk BETWEEN '1700-1759' AND '1800-1859' AND DestCityName BETWEEN 'Grand Rapids, MI' AND 'State College, PA' ORDER BY ArrivalDelayGroups LIMIT 4"}
+{"sql":"SELECT DepDelayMinutes, WheelsOn, DayOfWeek FROM mytable WHERE CancellationCode <= 'A' OR \"Year\" NOT IN (2014) AND TaxiIn BETWEEN 50 AND 29 ORDER BY DayOfWeek LIMIT 17","hsqls":["SELECT DepDelayMinutes, WheelsOn, DayOfWeek FROM mytable WHERE CancellationCode <= 'A' OR Year NOT IN (2014) AND TaxiIn BETWEEN 50 AND 29 ORDER BY DayOfWeek LIMIT 17"]}
+{"sql":"SELECT DepartureDelayGroups, ArrDel15, DepTimeBlk, DistanceGroup, Diverted, ActualElapsedTime FROM mytable ORDER BY DistanceGroup, Diverted, ActualElapsedTime LIMIT 26"}
+{"sql":"SELECT DestWac, OriginCityName, ArrDel15, DepDel15, \"Month\" FROM mytable ORDER BY DestWac, DepDel15, \"Month\" LIMIT 14","hsqls":["SELECT DestWac, OriginCityName, ArrDel15, DepDel15, Month FROM mytable ORDER BY DestWac, DepDel15, Month LIMIT 14"]}
+{"sql":"SELECT DivAirportLandings, Flights, OriginCityName FROM mytable ORDER BY Flights, OriginCityName LIMIT 15"}
+{"sql":"SELECT FlightDate, DestAirportID, OriginStateName FROM mytable ORDER BY DestAirportID, OriginStateName LIMIT 22"}
+{"sql":"SELECT LateAircraftDelay, OriginStateFips, DayOfWeek, CRSArrTime, AirTime, DayofMonth FROM mytable WHERE DivDistance IN (68, 577) AND DestAirportID NOT IN (14100, 10792, 13487) ORDER BY CRSArrTime, AirTime, DayofMonth LIMIT 25"}
+{"sql":"SELECT LongestAddGTime, DestCityMarketID FROM mytable WHERE TailNum IN ('N732US', 'N4YBAA', 'N349NW') AND DivActualElapsedTime NOT IN (368, 219, 218, 350) AND TaxiOut IN (93, 81) ORDER BY DestCityMarketID LIMIT 9"}
+{"sql":"SELECT NASDelay, Origin FROM mytable WHERE Dest BETWEEN 'SPI' AND 'SAV' OR DepDel15 BETWEEN 1 AND -9999 ORDER BY Origin LIMIT 9"}
+{"sql":"SELECT Origin, FlightDate FROM mytable WHERE ArrTimeBlk BETWEEN '0600-0659' AND '2100-2159' OR DistanceGroup NOT IN (7, 11) ORDER BY FlightDate LIMIT 26"}
+{"sql":"SELECT OriginAirportSeqID, \"Year\", Distance, ActualElapsedTime FROM mytable WHERE ArrDelayMinutes IN (122.0) ORDER BY Distance, ActualElapsedTime LIMIT 2","hsqls":["SELECT OriginAirportSeqID, Year, Distance, ActualElapsedTime FROM mytable WHERE ArrDelayMinutes IN (122.0) ORDER BY Distance, ActualElapsedTime LIMIT 2"]}
+{"sql":"SELECT OriginState, FlightNum, OriginStateName, DistanceGroup, DepDelay FROM mytable ORDER BY DistanceGroup, DepDelay LIMIT 8"}
+{"sql":"SELECT Quarter, DepDelayMinutes, DistanceGroup FROM mytable WHERE DepDelayMinutes < 26.0 OR TailNum < 'N439US' AND CancellationCode BETWEEN 'C' AND 'A' ORDER BY DistanceGroup LIMIT 15"}
+{"sql":"SELECT SecurityDelay, ArrDelay, ActualElapsedTime FROM mytable WHERE DistanceGroup BETWEEN 3 AND 8 AND Dest NOT IN ('HOU', 'GSP') ORDER BY ActualElapsedTime, ArrDelay LIMIT 7"}
+{"sql":"SELECT TailNum, OriginCityName, Dest FROM mytable WHERE ActualElapsedTime BETWEEN 125 AND 299 AND OriginCityMarketID NOT IN (31884, 35991, 30073, 32335, 33264) AND DepDelayMinutes BETWEEN 338.0 AND 186.0 ORDER BY OriginCityName, Dest LIMIT 18"}
+{"sql":"SELECT TaxiIn, WheelsOff, DestStateFips FROM mytable WHERE ActualElapsedTime IN (408, 251, 403, 310) ORDER BY WheelsOff, DestStateFips LIMIT 25"}
+{"sql":"SELECT TaxiOut, Flights, OriginCityMarketID FROM mytable WHERE CRSDepTime NOT IN (2210, 716, 1510, 1153, 1517) AND ArrTimeBlk BETWEEN '1900-1959' AND '0700-0759' ORDER BY Flights, OriginCityMarketID LIMIT 25"}
+{"sql":"SELECT TotalAddGTime, Flights FROM mytable WHERE DestStateFips NOT IN (48, 35, 22, 36, 39) AND CRSElapsedTime > 146 AND DivArrDelay BETWEEN 353 AND 328 ORDER BY Flights LIMIT 11"}
+{"sql":"SELECT UniqueCarrier, Flights, DestCityName, OriginStateName FROM mytable WHERE ActualElapsedTime BETWEEN 404 AND 43 ORDER BY Flights, DestCityName, OriginStateName LIMIT 5"}
+{"sql":"SELECT WeatherDelay, Cancelled, Dest, OriginAirportID FROM mytable WHERE AirTime <= 329 OR AirlineID < 20366 OR AirlineID BETWEEN 20304 AND 19805 ORDER BY OriginAirportID LIMIT 22"}
+{"sql":"SELECT WheelsOff, TotalAddGTime, \"Month\", OriginState FROM mytable ORDER BY OriginState LIMIT 24","hsqls":["SELECT WheelsOff, TotalAddGTime, Month, OriginState FROM mytable ORDER BY OriginState LIMIT 24"]}
+{"sql":"SELECT WheelsOn, OriginState FROM mytable WHERE DepartureDelayGroups > -2 ORDER BY OriginState LIMIT 20"}
+{"sql":"SELECT \"Year\", DepTime FROM mytable WHERE CRSArrTime BETWEEN 1237 AND 1534 AND Cancelled BETWEEN 0 AND 1 ORDER BY DepTime LIMIT 3","hsqls":["SELECT Year, DepTime FROM mytable WHERE CRSArrTime BETWEEN 1237 AND 1534 AND Cancelled BETWEEN 0 AND 1 ORDER BY DepTime LIMIT 3"]}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org