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 18:40:19 UTC
[incubator-pinot] branch master updated: Reduce pql queries from
10k to 500 (#6181)
This is an automated email from the ASF dual-hosted git repository.
jlli pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-pinot.git
The following commit(s) were added to refs/heads/master by this push:
new 5beb83a Reduce pql queries from 10k to 500 (#6181)
5beb83a is described below
commit 5beb83abbb1899c27b6625cc5888857f82c5eb01
Author: Jialiang Li <jl...@linkedin.com>
AuthorDate: Mon Oct 26 11:39:56 2020 -0700
Reduce pql queries from 10k to 500 (#6181)
Co-authored-by: Jack Li(Analytics Engineering) <jl...@jlli-mn1.linkedin.biz>
---
.../tests/BaseClusterIntegrationTestSet.java | 19 +-
...e_Performance_2014_100k_subset.test_queries_500 | 510 +++++++++++++++++++++
2 files changed, 517 insertions(+), 12 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 a524047..a937384 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
@@ -60,7 +60,7 @@ public abstract class BaseClusterIntegrationTestSet extends BaseClusterIntegrati
// Default settings
private static final String DEFAULT_PQL_QUERY_FILE_NAME =
- "On_Time_On_Time_Performance_2014_100k_subset.test_queries_10K";
+ "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";
private static final int DEFAULT_NUM_QUERIES_TO_GENERATE = 100;
@@ -320,18 +320,13 @@ public abstract class BaseClusterIntegrationTestSet extends BaseClusterIntegrati
assertNotNull(resourceUrl);
File queryFile = new File(resourceUrl.getFile());
- int maxNumQueriesToSkipInQueryFile = getMaxNumQueriesToSkipInQueryFile();
try (BufferedReader reader = new BufferedReader(new FileReader(queryFile))) {
- while (true) {
- int numQueriesSkipped = RANDOM.nextInt(maxNumQueriesToSkipInQueryFile);
- for (int i = 0; i < numQueriesSkipped; i++) {
- reader.readLine();
- }
-
- String queryString = reader.readLine();
- // 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
new file mode 100644
index 0000000..7c8f6e4
--- /dev/null
+++ b/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_500
@@ -0,0 +1,510 @@
+# Aggregation
+{"hsqls":["SELECT sum(DepartureDelayGroups) FROM mytable LIMIT 10000","SELECT MIN(FlightNum) FROM mytable LIMIT 10000","SELECT MAX(AirlineID) FROM mytable LIMIT 10000","SELECT AVG(CAST(Year AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT sum(DepartureDelayGroups), min(FlightNum), MAX(AirlineID), AVG(Year) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(ActualElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(DivDistance) FROM mytable LIMIT 10000","SELECT MIN(DepDelay) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(ActualElapsedTime), COUNT(DivDistance), MIN(DepDelay) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(ArrTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DivDistance AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(NASDelay) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(ArrTime), AVG(DivDistance), MIN(NASDelay) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(CRSDepTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(ArrDel15 AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(DepartureDelayGroups) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(CRSDepTime), AVG(ArrDel15), MAX(DepartureDelayGroups) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(CRSElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(CRSElapsedTime) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(Cancelled AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(Cancelled) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(CarrierDelay AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(DivReachedDest) FROM mytable LIMIT 10000","SELECT MIN(FirstDepTime) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(CarrierDelay), MIN(DivReachedDest), MIN(FirstDepTime) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DestAirportID AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DepTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DayOfWeek), AVG(DestAirportID), AVG(DepTime) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(DepDel15 AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(LateAircraftDelay) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DepDel15), MAX(LateAircraftDelay) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(DestAirportID AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(FlightNum) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DestAirportID), SUM(FlightNum) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(DestAirportSeqID AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DestCityMarketID AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DestAirportSeqID), AVG(DestCityMarketID) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(DestStateFips AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(DepTime) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DestStateFips), MAX(DepTime) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(DestStateFips AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(LateAircraftDelay) FROM mytable LIMIT 10000","SELECT COUNT(FlightDate) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DestStateFips), MAX(LateAircraftDelay), COUNT(FlightDate) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(DivActualElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DivActualElapsedTime) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(DivReachedDest AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(TaxiIn) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DivReachedDest), COUNT(TaxiIn) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(NASDelay AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(NASDelay) FROM mytable TOP 18"}
+{"hsqls":["SELECT AVG(CAST(OriginAirportSeqID AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(OriginAirportID) FROM mytable LIMIT 10000","SELECT MIN(TaxiOut) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(OriginAirportSeqID), SUM(OriginAirportID), MIN(TaxiOut) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(Quarter AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(FirstDepTime) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(Quarter), MIN(FirstDepTime) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(TotalAddGTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(DivAirportLandings) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(TotalAddGTime), COUNT(DivAirportLandings) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(TotalAddGTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(CRSDepTime) FROM mytable LIMIT 10000","SELECT AVG(CAST(DepDelayMinutes AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(TotalAddGTime), MAX(CRSDepTime), AVG(DepDelayMinutes) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(WheelsOn AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(WheelsOff AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(WheelsOn), AVG(WheelsOff) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(Year AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DivReachedDest AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(ArrDel15) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(Year), AVG(DivReachedDest), MIN(ArrDel15) FROM mytable"}
+{"hsqls":["SELECT COUNT(*) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable"}
+{"hsqls":["SELECT COUNT(ArrTimeBlk) FROM mytable LIMIT 10000","SELECT AVG(CAST(Cancelled AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(CarrierDelay) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(ArrTimeBlk), AVG(Cancelled), COUNT(CarrierDelay) FROM mytable"}
+{"hsqls":["SELECT COUNT(ArrivalDelayGroups) FROM mytable LIMIT 10000","SELECT MIN(DepartureDelayGroups) FROM mytable LIMIT 10000","SELECT SUM(AirlineID) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(ArrivalDelayGroups), MIN(DepartureDelayGroups), SUM(AirlineID) FROM mytable"}
+{"hsqls":["SELECT COUNT(CRSElapsedTime) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(CRSElapsedTime) FROM mytable"}
+{"hsqls":["SELECT COUNT(Cancelled) FROM mytable LIMIT 10000","SELECT AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(Cancelled), AVG(LateAircraftDelay) FROM mytable"}
+{"hsqls":["SELECT COUNT(Carrier) FROM mytable LIMIT 10000","SELECT AVG(CAST(DivDistance AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(DistanceGroup) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(Carrier), AVG(DivDistance), SUM(DistanceGroup) FROM mytable"}
+{"hsqls":["SELECT COUNT(CarrierDelay) FROM mytable LIMIT 10000","SELECT SUM(DepartureDelayGroups) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(CarrierDelay), SUM(DepartureDelayGroups) FROM mytable"}
+{"hsqls":["SELECT MAX(ArrDelay) FROM mytable LIMIT 10000","SELECT AVG(CAST(Distance AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(DayofMonth) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(ArrDelay), AVG(Distance), MIN(DayofMonth) FROM mytable"}
+{"hsqls":["SELECT MAX(CRSArrTime) FROM mytable LIMIT 10000","SELECT SUM(ArrDelay) FROM mytable LIMIT 10000","SELECT MAX(DayOfWeek) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(CRSArrTime), SUM(ArrDelay), MAX(DayOfWeek) FROM mytable "}
+{"hsqls":["SELECT MAX(DaysSinceEpoch) FROM mytable LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DaysSinceEpoch), SUM(DestStateFips) FROM mytable"}
+{"hsqls":["SELECT MAX(OriginAirportID) FROM mytable LIMIT 10000","SELECT COUNT(WheelsOff) FROM mytable LIMIT 10000","SELECT COUNT(TailNum) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(OriginAirportID), COUNT(WheelsOff), COUNT(TailNum) FROM mytable"}
+{"hsqls":["SELECT MAX(OriginAirportSeqID) FROM mytable LIMIT 10000","SELECT AVG(CAST(Cancelled AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(Cancelled) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(OriginAirportSeqID), AVG(Cancelled), COUNT(Cancelled) FROM mytable"}
+{"hsqls":["SELECT MIN(CRSDepTime) FROM mytable LIMIT 10000","SELECT SUM(ActualElapsedTime) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(CRSDepTime), SUM(ActualElapsedTime) FROM mytable"}
+{"hsqls":["SELECT MIN(CRSElapsedTime) FROM mytable LIMIT 10000","SELECT AVG(CAST(DivActualElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(CRSElapsedTime), AVG(DivActualElapsedTime) FROM mytable"}
+{"hsqls":["SELECT MIN(CarrierDelay) FROM mytable LIMIT 10000","SELECT SUM(Diverted) FROM mytable LIMIT 10000","SELECT SUM(DestWac) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(CarrierDelay), SUM(Diverted), SUM(DestWac) FROM mytable"}
+{"hsqls":["SELECT MIN(DayOfWeek) FROM mytable LIMIT 10000","SELECT COUNT(AirlineID) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(DayOfWeek), COUNT(AirlineID) FROM mytable"}
+{"hsqls":["SELECT MIN(DepDelayMinutes) FROM mytable LIMIT 10000","SELECT AVG(CAST(WeatherDelay AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(Cancelled) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(DepDelayMinutes), AVG(WeatherDelay), SUM(Cancelled) FROM mytable"}
+{"hsqls":["SELECT MIN(DivActualElapsedTime) FROM mytable LIMIT 10000","SELECT AVG(CAST(OriginCityMarketID AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(DivActualElapsedTime), AVG(OriginCityMarketID) FROM mytable"}
+{"hsqls":["SELECT SUM(ArrDelayMinutes) FROM mytable LIMIT 10000","SELECT MIN(OriginAirportID) FROM mytable LIMIT 10000","SELECT MIN(ArrDelay) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(ArrDelayMinutes), MIN(OriginAirportID), MIN(ArrDelay) FROM mytable"}
+{"hsqls":["SELECT SUM(ArrivalDelayGroups) FROM mytable LIMIT 10000","SELECT AVG(CAST(Flights AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups), AVG(Flights) FROM mytable"}
+{"hsqls":["SELECT SUM(CRSDepTime) FROM mytable LIMIT 10000","SELECT MAX(OriginWac) FROM mytable LIMIT 10000","SELECT MAX(ArrTime) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(CRSDepTime), MAX(OriginWac), MAX(ArrTime) FROM mytable"}
+{"hsqls":["SELECT SUM(Cancelled) FROM mytable LIMIT 10000","SELECT SUM(DaysSinceEpoch) FROM mytable LIMIT 10000","SELECT COUNT(DestState) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(Cancelled), SUM(DaysSinceEpoch), COUNT(DestState) FROM mytable"}
+{"hsqls":["SELECT SUM(LongestAddGTime) FROM mytable LIMIT 10000","SELECT MIN(TaxiIn) FROM mytable LIMIT 10000","SELECT AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(LongestAddGTime), MIN(TaxiIn), AVG(LateAircraftDelay) FROM mytable"}
+{"hsqls":["SELECT SUM(NASDelay) FROM mytable LIMIT 10000","SELECT MAX(WheelsOff) FROM mytable LIMIT 10000","SELECT SUM(ArrDelay) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(NASDelay), MAX(WheelsOff), SUM(ArrDelay) FROM mytable"}
+{"hsqls":["SELECT SUM(OriginAirportID) FROM mytable LIMIT 10000","SELECT COUNT(TailNum) FROM mytable LIMIT 10000","SELECT MIN(DestStateFips) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(OriginAirportID), COUNT(TailNum), MIN(DestStateFips) FROM mytable"}
+{"hsqls":["SELECT SUM(Quarter) FROM mytable LIMIT 10000","SELECT COUNT(DepTime) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(Quarter), COUNT(DepTime) FROM mytable"}
+{"hsqls":["SELECT SUM(WheelsOff) FROM mytable LIMIT 10000","SELECT SUM(CRSArrTime) FROM mytable LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(WheelsOff), SUM(CRSArrTime), SUM(DestStateFips) FROM mytable"}
+{"hsqls":["SELECT SUM(Year) FROM mytable LIMIT 10000","SELECT AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(Year), AVG(OriginStateFips) FROM mytable"}
+
+# Grouping on Aggregation
+{"hsqls":["SELECT WheelsOn, COUNT(*) FROM mytable GROUP BY WheelsOn LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY WheelsOn TOP 25"}
+{"hsqls":["SELECT DestAirportID, MIN(DepartureDelayGroups) FROM mytable GROUP BY DestAirportID LIMIT 10000","SELECT DestAirportID, COUNT(DivDistance) FROM mytable GROUP BY DestAirportID LIMIT 10000"],"pql":"SELECT MIN(DepartureDelayGroups), COUNT(DivDistance) FROM mytable GROUP BY DestAirportID TOP 6"}
+{"hsqls":["SELECT AirTime, AVG(CAST(LongestAddGTime AS DOUBLE)) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, AVG(CAST(OriginCityMarketID AS DOUBLE)) FROM mytable GROUP BY AirTime LIMIT 10000"],"pql":"SELECT AVG(LongestAddGTime), AVG(OriginCityMarketID) FROM mytable GROUP BY AirTime TOP 8"}
+{"hsqls":["SELECT AirTime, CancellationCode, AVG(CAST(Month AS DOUBLE)) FROM mytable GROUP BY AirTime, CancellationCode LIMIT 10000","SELECT AirTime, CancellationCode, MIN(OriginWac) FROM mytable GROUP BY AirTime, CancellationCode LIMIT 10000","SELECT AirTime, CancellationCode, SUM(DepTime) FROM mytable GROUP BY AirTime, CancellationCode LIMIT 10000"],"pql":"SELECT AVG(Month), MIN(OriginWac), SUM(DepTime) FROM mytable GROUP BY AirTime, CancellationCode TOP 3"}
+{"hsqls":["SELECT ArrDel15, AVG(CAST(Diverted AS DOUBLE)) FROM mytable GROUP BY ArrDel15 LIMIT 10000"],"pql":"SELECT AVG(Diverted) FROM mytable GROUP BY ArrDel15 TOP 18"}
+{"hsqls":["SELECT ArrDelay, AVG(CAST(DepDel15 AS DOUBLE)) FROM mytable GROUP BY ArrDelay LIMIT 10000","SELECT ArrDelay, SUM(LongestAddGTime) FROM mytable GROUP BY ArrDelay LIMIT 10000"],"pql":"SELECT AVG(DepDel15), SUM(LongestAddGTime) FROM mytable GROUP BY ArrDelay TOP 5"}
+{"hsqls":["SELECT ArrDelayMinutes, AVG(CAST(ArrDel15 AS DOUBLE)) FROM mytable GROUP BY ArrDelayMinutes LIMIT 10000"],"pql":"SELECT AVG(ArrDel15) FROM mytable GROUP BY ArrDelayMinutes TOP 2"}
+{"hsqls":["SELECT ArrTimeBlk, OriginStateName, AVG(CAST(WeatherDelay AS DOUBLE)) FROM mytable GROUP BY ArrTimeBlk, OriginStateName LIMIT 10000","SELECT ArrTimeBlk, OriginStateName, SUM(CarrierDelay) FROM mytable GROUP BY ArrTimeBlk, OriginStateName LIMIT 10000","SELECT ArrTimeBlk, OriginStateName, SUM(CRSElapsedTime) FROM mytable GROUP BY ArrTimeBlk, OriginStateName LIMIT 10000"],"pql":"SELECT AVG(WeatherDelay), SUM(CarrierDelay), SUM(CRSElapsedTime) FROM mytable GROUP BY ArrTimeBlk, Ori [...]
+{"hsqls":["SELECT ArrivalDelayGroups, AVG(CAST(DestCityMarketID AS DOUBLE)) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, COUNT(Diverted) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT AVG(DestCityMarketID), COUNT(Diverted), AVG(LateAircraftDelay) FROM mytable GROUP BY ArrivalDelayGroups TOP 19"}
+{"hsqls":["SELECT Cancelled, DepDel15, AVG(CAST(DepDelay AS DOUBLE)) FROM mytable GROUP BY Cancelled, DepDel15 LIMIT 10000","SELECT Cancelled, DepDel15, AVG(CAST(DivArrDelay AS DOUBLE)) FROM mytable GROUP BY Cancelled, DepDel15 LIMIT 10000","SELECT Cancelled, DepDel15, AVG(CAST(DepartureDelayGroups AS DOUBLE)) FROM mytable GROUP BY Cancelled, DepDel15 LIMIT 10000"],"pql":"SELECT AVG(DepDelay), AVG(DivArrDelay), AVG(DepartureDelayGroups) FROM mytable GROUP BY Cancelled, DepDel15 TOP 26"}
+{"hsqls":["SELECT Carrier, AVG(CAST(DaysSinceEpoch AS DOUBLE)) FROM mytable GROUP BY Carrier LIMIT 10000","SELECT Carrier, SUM(OriginWac) FROM mytable GROUP BY Carrier LIMIT 10000","SELECT Carrier, SUM(DestCityMarketID) FROM mytable GROUP BY Carrier LIMIT 10000"],"pql":"SELECT AVG(DaysSinceEpoch), SUM(OriginWac), SUM(DestCityMarketID) FROM mytable GROUP BY Carrier"}
+{"hsqls":["SELECT CarrierDelay, AVG(CAST(DayofMonth AS DOUBLE)) FROM mytable GROUP BY CarrierDelay LIMIT 10000","SELECT CarrierDelay, MIN(DepDel15) FROM mytable GROUP BY CarrierDelay LIMIT 10000","SELECT CarrierDelay, SUM(Quarter) FROM mytable GROUP BY CarrierDelay LIMIT 10000"],"pql":"SELECT AVG(DayofMonth), MIN(DepDel15), SUM(Quarter) FROM mytable GROUP BY CarrierDelay TOP 26"}
+{"hsqls":["SELECT DayOfWeek, AVG(CAST(TaxiOut AS DOUBLE)) FROM mytable GROUP BY DayOfWeek LIMIT 10000","SELECT DayOfWeek, AVG(CAST(DepartureDelayGroups AS DOUBLE)) FROM mytable GROUP BY DayOfWeek LIMIT 10000","SELECT DayOfWeek, MAX(DivAirportLandings) FROM mytable GROUP BY DayOfWeek LIMIT 10000"],"pql":"SELECT AVG(TaxiOut), AVG(DepartureDelayGroups), MAX(DivAirportLandings) FROM mytable GROUP BY DayOfWeek TOP 9"}
+{"hsqls":["SELECT DaysSinceEpoch, AVG(CAST(Distance AS DOUBLE)) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000","SELECT DaysSinceEpoch, MIN(AirlineID) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000"],"pql":"SELECT AVG(Distance), MIN(AirlineID) FROM mytable GROUP BY DaysSinceEpoch TOP 14"}
+{"hsqls":["SELECT DepDelay, CarrierDelay, SecurityDelay, AVG(CAST(DepDelay AS DOUBLE)) FROM mytable GROUP BY DepDelay, CarrierDelay, SecurityDelay LIMIT 10000","SELECT DepDelay, CarrierDelay, SecurityDelay, AVG(CAST(OriginAirportID AS DOUBLE)) FROM mytable GROUP BY DepDelay, CarrierDelay, SecurityDelay LIMIT 10000"],"pql":"SELECT AVG(DepDelay), AVG(OriginAirportID) FROM mytable GROUP BY DepDelay, CarrierDelay, SecurityDelay TOP 1"}
+{"hsqls":["SELECT DepDelay, NASDelay, AVG(CAST(NASDelay AS DOUBLE)) FROM mytable GROUP BY DepDelay, NASDelay LIMIT 10000","SELECT DepDelay, NASDelay, MIN(TotalAddGTime) FROM mytable GROUP BY DepDelay, NASDelay LIMIT 10000","SELECT DepDelay, NASDelay, MIN(FirstDepTime) FROM mytable GROUP BY DepDelay, NASDelay LIMIT 10000"],"pql":"SELECT AVG(NASDelay), MIN(TotalAddGTime), MIN(FirstDepTime) FROM mytable GROUP BY DepDelay, NASDelay TOP 2"}
+{"hsqls":["SELECT DepDelayMinutes, AVG(CAST(Cancelled AS DOUBLE)) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000","SELECT DepDelayMinutes, MIN(ActualElapsedTime) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000"],"pql":"SELECT AVG(Cancelled), MIN(ActualElapsedTime) FROM mytable GROUP BY DepDelayMinutes TOP 17"}
+{"hsqls":["SELECT FlightDate, Cancelled, AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable GROUP BY FlightDate, Cancelled LIMIT 10000","SELECT FlightDate, Cancelled, MIN(DivArrDelay) FROM mytable GROUP BY FlightDate, Cancelled LIMIT 10000"],"pql":"SELECT AVG(DayOfWeek), MIN(DivArrDelay) FROM mytable GROUP BY FlightDate, Cancelled TOP 14"}
+{"hsqls":["SELECT FlightNum, AVG(CAST(DistanceGroup AS DOUBLE)) FROM mytable GROUP BY FlightNum LIMIT 10000"],"pql":"SELECT AVG(DistanceGroup) FROM mytable GROUP BY FlightNum TOP 14"}
+{"hsqls":["SELECT LateAircraftDelay, DestStateFips, DivArrDelay, AVG(CAST(DestAirportID AS DOUBLE)) FROM mytable GROUP BY LateAircraftDelay, DestStateFips, DivArrDelay LIMIT 10000","SELECT LateAircraftDelay, DestStateFips, DivArrDelay, COUNT(DivArrDelay) FROM mytable GROUP BY LateAircraftDelay, DestStateFips, DivArrDelay LIMIT 10000","SELECT LateAircraftDelay, DestStateFips, DivArrDelay, COUNT(ArrDel15) FROM mytable GROUP BY LateAircraftDelay, DestStateFips, DivArrDelay LIMIT 10000"],"pq [...]
+{"hsqls":["SELECT LateAircraftDelay, FirstDepTime, DivDistance, AVG(CAST(FlightNum AS DOUBLE)) FROM mytable GROUP BY LateAircraftDelay, FirstDepTime, DivDistance LIMIT 10000","SELECT LateAircraftDelay, FirstDepTime, DivDistance, MIN(OriginWac) FROM mytable GROUP BY LateAircraftDelay, FirstDepTime, DivDistance LIMIT 10000","SELECT LateAircraftDelay, FirstDepTime, DivDistance, MIN(CRSElapsedTime) FROM mytable GROUP BY LateAircraftDelay, FirstDepTime, DivDistance LIMIT 10000"],"pql":"SELECT [...]
+{"hsqls":["SELECT LateAircraftDelay, OriginWac, AVG(CAST(WeatherDelay AS DOUBLE)) FROM mytable GROUP BY LateAircraftDelay, OriginWac LIMIT 10000","SELECT LateAircraftDelay, OriginWac, AVG(CAST(CRSDepTime AS DOUBLE)) FROM mytable GROUP BY LateAircraftDelay, OriginWac LIMIT 10000","SELECT LateAircraftDelay, OriginWac, MAX(CRSDepTime) FROM mytable GROUP BY LateAircraftDelay, OriginWac LIMIT 10000"],"pql":"SELECT AVG(WeatherDelay), AVG(CRSDepTime), MAX(CRSDepTime) FROM mytable GROUP BY LateA [...]
+{"hsqls":["SELECT LongestAddGTime, Origin, DayofMonth, AVG(CAST(TaxiOut AS DOUBLE)) FROM mytable GROUP BY LongestAddGTime, Origin, DayofMonth LIMIT 10000","SELECT LongestAddGTime, Origin, DayofMonth, SUM(TaxiIn) FROM mytable GROUP BY LongestAddGTime, Origin, DayofMonth LIMIT 10000"],"pql":"SELECT AVG(TaxiOut), SUM(TaxiIn) FROM mytable GROUP BY LongestAddGTime, Origin, DayofMonth TOP 7"}
+{"hsqls":["SELECT Month, AVG(CAST(Month AS DOUBLE)) FROM mytable GROUP BY Month LIMIT 10000","SELECT Month, AVG(CAST(AirTime AS DOUBLE)) FROM mytable GROUP BY Month LIMIT 10000"],"pql":"SELECT AVG(Month), AVG(AirTime) FROM mytable GROUP BY Month TOP 10"}
+{"hsqls":["SELECT Origin, AVG(CAST(OriginAirportSeqID AS DOUBLE)) FROM mytable GROUP BY Origin LIMIT 10000","SELECT Origin, MIN(FirstDepTime) FROM mytable GROUP BY Origin LIMIT 10000","SELECT Origin, MIN(Distance) FROM mytable GROUP BY Origin LIMIT 10000"],"pql":"SELECT AVG(OriginAirportSeqID), MIN(FirstDepTime), MIN(Distance) FROM mytable GROUP BY Origin TOP 10"}
+{"hsqls":["SELECT OriginAirportSeqID, DepTimeBlk, AVG(CAST(Diverted AS DOUBLE)) FROM mytable GROUP BY OriginAirportSeqID, DepTimeBlk LIMIT 10000","SELECT OriginAirportSeqID, DepTimeBlk, MIN(DestStateFips) FROM mytable GROUP BY OriginAirportSeqID, DepTimeBlk LIMIT 10000","SELECT OriginAirportSeqID, DepTimeBlk, SUM(ArrTime) FROM mytable GROUP BY OriginAirportSeqID, DepTimeBlk LIMIT 10000"],"pql":"SELECT AVG(Diverted), MIN(DestStateFips), SUM(ArrTime) FROM mytable GROUP BY OriginAirportSeqI [...]
+{"hsqls":["SELECT OriginCityMarketID, DestStateFips, TotalAddGTime, AVG(CAST(SecurityDelay AS DOUBLE)) FROM mytable GROUP BY OriginCityMarketID, DestStateFips, TotalAddGTime LIMIT 10000","SELECT OriginCityMarketID, DestStateFips, TotalAddGTime, SUM(DestCityMarketID) FROM mytable GROUP BY OriginCityMarketID, DestStateFips, TotalAddGTime LIMIT 10000"],"pql":"SELECT AVG(SecurityDelay), SUM(DestCityMarketID) FROM mytable GROUP BY OriginCityMarketID, DestStateFips, TotalAddGTime TOP 23"}
+{"hsqls":["SELECT OriginWac, OriginAirportID, AVG(CAST(ArrTime AS DOUBLE)) FROM mytable GROUP BY OriginWac, OriginAirportID LIMIT 10000","SELECT OriginWac, OriginAirportID, MAX(DestAirportID) FROM mytable GROUP BY OriginWac, OriginAirportID LIMIT 10000"],"pql":"SELECT AVG(ArrTime), MAX(DestAirportID) FROM mytable GROUP BY OriginWac, OriginAirportID TOP 13"}
+{"hsqls":["SELECT Quarter, AVG(CAST(CRSDepTime AS DOUBLE)) FROM mytable GROUP BY Quarter LIMIT 10000","SELECT Quarter, SUM(OriginAirportID) FROM mytable GROUP BY Quarter LIMIT 10000"],"pql":"SELECT AVG(CRSDepTime), SUM(OriginAirportID) FROM mytable GROUP BY Quarter TOP 6"}
+{"hsqls":["SELECT SecurityDelay, AVG(CAST(OriginWac AS DOUBLE)) FROM mytable GROUP BY SecurityDelay LIMIT 10000","SELECT SecurityDelay, COUNT(OriginStateName) FROM mytable GROUP BY SecurityDelay LIMIT 10000","SELECT SecurityDelay, AVG(CAST(OriginCityMarketID AS DOUBLE)) FROM mytable GROUP BY SecurityDelay LIMIT 10000"],"pql":"SELECT AVG(OriginWac), COUNT(OriginStateName), AVG(OriginCityMarketID) FROM mytable GROUP BY SecurityDelay"}
+{"hsqls":["SELECT TailNum, AVG(CAST(Year AS DOUBLE)) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, MIN(DestCityMarketID) FROM mytable GROUP BY TailNum LIMIT 10000"],"pql":"SELECT AVG(Year), MIN(DestCityMarketID) FROM mytable GROUP BY TailNum TOP 24"}
+{"hsqls":["SELECT TotalAddGTime, AVG(CAST(DestStateFips AS DOUBLE)) FROM mytable GROUP BY TotalAddGTime LIMIT 10000","SELECT TotalAddGTime, MAX(CRSDepTime) FROM mytable GROUP BY TotalAddGTime LIMIT 10000","SELECT TotalAddGTime, COUNT(TailNum) FROM mytable GROUP BY TotalAddGTime LIMIT 10000"],"pql":"SELECT AVG(DestStateFips), MAX(CRSDepTime), COUNT(TailNum) FROM mytable GROUP BY TotalAddGTime TOP 3"}
+{"hsqls":["SELECT UniqueCarrier, AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, MAX(DivReachedDest) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, MAX(ActualElapsedTime) FROM mytable GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT AVG(DayOfWeek), MAX(DivReachedDest), MAX(ActualElapsedTime) FROM mytable GROUP BY UniqueCarrier TOP 29"}
+{"hsqls":["SELECT UniqueCarrier, OriginAirportID, AVG(CAST(LongestAddGTime AS DOUBLE)) FROM mytable GROUP BY UniqueCarrier, OriginAirportID LIMIT 10000"],"pql":"SELECT AVG(LongestAddGTime) FROM mytable GROUP BY UniqueCarrier, OriginAirportID TOP 1"}
+{"hsqls":["SELECT Year, Diverted, AVG(CAST(TaxiIn AS DOUBLE)) FROM mytable GROUP BY Year, Diverted LIMIT 10000","SELECT Year, Diverted, SUM(DivArrDelay) FROM mytable GROUP BY Year, Diverted LIMIT 10000"],"pql":"SELECT AVG(TaxiIn), SUM(DivArrDelay) FROM mytable GROUP BY Year, Diverted"}
+{"hsqls":["SELECT ActualElapsedTime, COUNT(DayofMonth) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000","SELECT ActualElapsedTime, AVG(CAST(Cancelled AS DOUBLE)) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000","SELECT ActualElapsedTime, MIN(OriginCityMarketID) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000"],"pql":"SELECT COUNT(DayofMonth), AVG(Cancelled), MIN(OriginCityMarketID) FROM mytable GROUP BY ActualElapsedTime TOP 22"}
+{"hsqls":["SELECT AirTime, COUNT(DestStateName) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, MAX(DepDel15) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, MIN(TaxiIn) FROM mytable GROUP BY AirTime LIMIT 10000"],"pql":"SELECT COUNT(DestStateName), MAX(DepDel15), MIN(TaxiIn) FROM mytable GROUP BY AirTime TOP 3"}
+{"hsqls":["SELECT ArrivalDelayGroups, COUNT(DivActualElapsedTime) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, MIN(ArrDel15) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, MIN(CarrierDelay) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUNT(DivActualElapsedTime), MIN(ArrDel15), MIN(CarrierDelay) FROM mytable GROUP BY ArrivalDelayGroups TOP 16"}
+{"hsqls":["SELECT ArrivalDelayGroups, COUNT(Flights) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, COUNT(DepTime) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUNT(Flights), COUNT(DepTime) FROM mytable GROUP BY ArrivalDelayGroups TOP 12"}
+{"hsqls":["SELECT CRSArrTime, COUNT(*) FROM mytable GROUP BY CRSArrTime LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY CRSArrTime TOP 28"}
+{"hsqls":["SELECT CRSArrTime, COUNT(AirTime) FROM mytable GROUP BY CRSArrTime LIMIT 10000","SELECT CRSArrTime, AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable GROUP BY CRSArrTime LIMIT 10000"],"pql":"SELECT COUNT(AirTime), AVG(LateAircraftDelay) FROM mytable GROUP BY CRSArrTime TOP 17"}
+{"hsqls":["SELECT CRSArrTime, COUNT(OriginAirportSeqID) FROM mytable GROUP BY CRSArrTime LIMIT 10000","SELECT CRSArrTime, MIN(AirTime) FROM mytable GROUP BY CRSArrTime LIMIT 10000"],"pql":"SELECT COUNT(OriginAirportSeqID), MIN(AirTime) FROM mytable GROUP BY CRSArrTime TOP 27"}
+{"hsqls":["SELECT Cancelled, DivAirportLandings, COUNT(*) FROM mytable GROUP BY Cancelled, DivAirportLandings LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY Cancelled, DivAirportLandings TOP 10"}
+{"hsqls":["SELECT Carrier, ArrDel15, ArrivalDelayGroups, COUNT(NASDelay) FROM mytable GROUP BY Carrier, ArrDel15, ArrivalDelayGroups LIMIT 10000","SELECT Carrier, ArrDel15, ArrivalDelayGroups, MAX(DivActualElapsedTime) FROM mytable GROUP BY Carrier, ArrDel15, ArrivalDelayGroups LIMIT 10000","SELECT Carrier, ArrDel15, ArrivalDelayGroups, MAX(CRSDepTime) FROM mytable GROUP BY Carrier, ArrDel15, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUNT(NASDelay), MAX(DivActualElapsedTime), MAX(C [...]
+{"hsqls":["SELECT DayOfWeek, COUNT(Origin) FROM mytable GROUP BY DayOfWeek LIMIT 10000"],"pql":"SELECT COUNT(Origin) FROM mytable GROUP BY DayOfWeek TOP 29"}
+{"hsqls":["SELECT DayofMonth, COUNT(ArrivalDelayGroups) FROM mytable GROUP BY DayofMonth LIMIT 10000","SELECT DayofMonth, AVG(CAST(DepartureDelayGroups AS DOUBLE)) FROM mytable GROUP BY DayofMonth LIMIT 10000"],"pql":"SELECT COUNT(ArrivalDelayGroups), AVG(DepartureDelayGroups) FROM mytable GROUP BY DayofMonth TOP 10"}
+{"hsqls":["SELECT DaysSinceEpoch, COUNT(DivDistance) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000","SELECT DaysSinceEpoch, AVG(CAST(Cancelled AS DOUBLE)) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000","SELECT DaysSinceEpoch, COUNT(LongestAddGTime) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000"],"pql":"SELECT COUNT(DivDistance), AVG(Cancelled), COUNT(LongestAddGTime) FROM mytable GROUP BY DaysSinceEpoch TOP 24"}
+{"hsqls":["SELECT DepDelayMinutes, COUNT(Origin) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000","SELECT DepDelayMinutes, MAX(NASDelay) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000"],"pql":"SELECT COUNT(Origin), MAX(NASDelay) FROM mytable GROUP BY DepDelayMinutes TOP 25"}
+{"hsqls":["SELECT DepTimeBlk, DivAirportLandings, COUNT(Dest) FROM mytable GROUP BY DepTimeBlk, DivAirportLandings LIMIT 10000","SELECT DepTimeBlk, DivAirportLandings, MIN(OriginAirportSeqID) FROM mytable GROUP BY DepTimeBlk, DivAirportLandings LIMIT 10000","SELECT DepTimeBlk, DivAirportLandings, AVG(CAST(NASDelay AS DOUBLE)) FROM mytable GROUP BY DepTimeBlk, DivAirportLandings LIMIT 10000"],"pql":"SELECT COUNT(Dest), MIN(OriginAirportSeqID), AVG(NASDelay) FROM mytable GROUP BY DepTimeBl [...]
+{"hsqls":["SELECT DepartureDelayGroups, LateAircraftDelay, COUNT(Flights) FROM mytable GROUP BY DepartureDelayGroups, LateAircraftDelay LIMIT 10000","SELECT DepartureDelayGroups, LateAircraftDelay, MIN(CRSElapsedTime) FROM mytable GROUP BY DepartureDelayGroups, LateAircraftDelay LIMIT 10000"],"pql":"SELECT COUNT(Flights), MIN(CRSElapsedTime) FROM mytable GROUP BY DepartureDelayGroups, LateAircraftDelay TOP 15"}
+{"hsqls":["SELECT DepartureDelayGroups, OriginCityName, DivAirportLandings, COUNT(*) FROM mytable GROUP BY DepartureDelayGroups, OriginCityName, DivAirportLandings LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY DepartureDelayGroups, OriginCityName, DivAirportLandings TOP 27"}
+{"hsqls":["SELECT Dest, AirlineID, COUNT(OriginCityMarketID) FROM mytable GROUP BY Dest, AirlineID LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID) FROM mytable GROUP BY Dest, AirlineID TOP 6"}
+{"hsqls":["SELECT Dest, ArrivalDelayGroups, COUNT(OriginCityMarketID) FROM mytable GROUP BY Dest, ArrivalDelayGroups LIMIT 10000","SELECT Dest, ArrivalDelayGroups, SUM(ArrDelay) FROM mytable GROUP BY Dest, ArrivalDelayGroups LIMIT 10000","SELECT Dest, ArrivalDelayGroups, AVG(CAST(CRSArrTime AS DOUBLE)) FROM mytable GROUP BY Dest, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID), SUM(ArrDelay), AVG(CRSArrTime) FROM mytable GROUP BY Dest, ArrivalDelayGroups TOP 8"}
+{"hsqls":["SELECT Dest, COUNT(OriginCityMarketID) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, MIN(OriginAirportSeqID) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, MIN(DivReachedDest) FROM mytable GROUP BY Dest LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID), MIN(OriginAirportSeqID), MIN(DivReachedDest) FROM mytable GROUP BY Dest TOP 15"}
+{"hsqls":["SELECT Dest, OriginStateName, COUNT(OriginState) FROM mytable GROUP BY Dest, OriginStateName LIMIT 10000","SELECT Dest, OriginStateName, MAX(Diverted) FROM mytable GROUP BY Dest, OriginStateName LIMIT 10000","SELECT Dest, OriginStateName, MAX(DayofMonth) FROM mytable GROUP BY Dest, OriginStateName LIMIT 10000"],"pql":"SELECT COUNT(OriginState), MAX(Diverted), MAX(DayofMonth) FROM mytable GROUP BY Dest, OriginStateName TOP 29"}
+{"hsqls":["SELECT DestAirportID, COUNT(DivArrDelay) FROM mytable GROUP BY DestAirportID LIMIT 10000","SELECT DestAirportID, MAX(Cancelled) FROM mytable GROUP BY DestAirportID LIMIT 10000","SELECT DestAirportID, MAX(OriginStateFips) FROM mytable GROUP BY DestAirportID LIMIT 10000"],"pql":"SELECT COUNT(DivArrDelay), MAX(Cancelled), MAX(OriginStateFips) FROM mytable GROUP BY DestAirportID TOP 11"}
+{"hsqls":["SELECT DestAirportSeqID, CancellationCode, COUNT(Quarter) FROM mytable GROUP BY DestAirportSeqID, CancellationCode LIMIT 10000","SELECT DestAirportSeqID, CancellationCode, AVG(CAST(DepTime AS DOUBLE)) FROM mytable GROUP BY DestAirportSeqID, CancellationCode LIMIT 10000","SELECT DestAirportSeqID, CancellationCode, SUM(DestStateFips) FROM mytable GROUP BY DestAirportSeqID, CancellationCode LIMIT 10000"],"pql":"SELECT COUNT(Quarter), AVG(DepTime), SUM(DestStateFips) FROM mytable [...]
+{"hsqls":["SELECT DestAirportSeqID, DepTimeBlk, COUNT(*) FROM mytable GROUP BY DestAirportSeqID, DepTimeBlk LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY DestAirportSeqID, DepTimeBlk TOP 25"}
+{"hsqls":["SELECT DestAirportSeqID, DestStateName, DivAirportLandings, COUNT(*) FROM mytable GROUP BY DestAirportSeqID, DestStateName, DivAirportLandings LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY DestAirportSeqID, DestStateName, DivAirportLandings TOP 17"}
+{"hsqls":["SELECT DestStateFips, TotalAddGTime, Month, COUNT(TaxiOut) FROM mytable GROUP BY DestStateFips, TotalAddGTime, Month LIMIT 10000","SELECT DestStateFips, TotalAddGTime, Month, COUNT(DestStateName) FROM mytable GROUP BY DestStateFips, TotalAddGTime, Month LIMIT 10000","SELECT DestStateFips, TotalAddGTime, Month, MIN(FirstDepTime) FROM mytable GROUP BY DestStateFips, TotalAddGTime, Month LIMIT 10000"],"pql":"SELECT COUNT(TaxiOut), COUNT(DestStateName), MIN(FirstDepTime) FROM myta [...]
+{"hsqls":["SELECT DestStateName, DestCityMarketID, COUNT(Carrier) FROM mytable GROUP BY DestStateName, DestCityMarketID LIMIT 10000","SELECT DestStateName, DestCityMarketID, COUNT(TaxiOut) FROM mytable GROUP BY DestStateName, DestCityMarketID LIMIT 10000","SELECT DestStateName, DestCityMarketID, SUM(Year) FROM mytable GROUP BY DestStateName, DestCityMarketID LIMIT 10000"],"pql":"SELECT COUNT(Carrier), COUNT(TaxiOut), SUM(Year) FROM mytable GROUP BY DestStateName, DestCityMarketID TOP 2"}
+{"hsqls":["SELECT DestWac, NASDelay, COUNT(Carrier) FROM mytable GROUP BY DestWac, NASDelay LIMIT 10000","SELECT DestWac, NASDelay, AVG(CAST(DayofMonth AS DOUBLE)) FROM mytable GROUP BY DestWac, NASDelay LIMIT 10000"],"pql":"SELECT COUNT(Carrier), AVG(DayofMonth) FROM mytable GROUP BY DestWac, NASDelay TOP 12"}
+{"hsqls":["SELECT DestWac, Quarter, OriginCityName, COUNT(DepDelay) FROM mytable GROUP BY DestWac, Quarter, OriginCityName LIMIT 10000","SELECT DestWac, Quarter, OriginCityName, COUNT(Diverted) FROM mytable GROUP BY DestWac, Quarter, OriginCityName LIMIT 10000","SELECT DestWac, Quarter, OriginCityName, COUNT(CarrierDelay) FROM mytable GROUP BY DestWac, Quarter, OriginCityName LIMIT 10000"],"pql":"SELECT COUNT(DepDelay), COUNT(Diverted), COUNT(CarrierDelay) FROM mytable GROUP BY DestWac, [...]
+{"hsqls":["SELECT DistanceGroup, ActualElapsedTime, COUNT(*) FROM mytable GROUP BY DistanceGroup, ActualElapsedTime LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY DistanceGroup, ActualElapsedTime TOP 1"}
+{"hsqls":["SELECT DistanceGroup, CancellationCode, COUNT(ArrTimeBlk) FROM mytable GROUP BY DistanceGroup, CancellationCode LIMIT 10000","SELECT DistanceGroup, CancellationCode, AVG(CAST(DayofMonth AS DOUBLE)) FROM mytable GROUP BY DistanceGroup, CancellationCode LIMIT 10000","SELECT DistanceGroup, CancellationCode, MIN(ActualElapsedTime) FROM mytable GROUP BY DistanceGroup, CancellationCode LIMIT 10000"],"pql":"SELECT COUNT(ArrTimeBlk), AVG(DayofMonth), MIN(ActualElapsedTime) FROM mytabl [...]
+{"hsqls":["SELECT DivDistance, DestAirportSeqID, Origin, COUNT(DestAirportSeqID) FROM mytable GROUP BY DivDistance, DestAirportSeqID, Origin LIMIT 10000","SELECT DivDistance, DestAirportSeqID, Origin, COUNT(Diverted) FROM mytable GROUP BY DivDistance, DestAirportSeqID, Origin LIMIT 10000","SELECT DivDistance, DestAirportSeqID, Origin, MIN(CRSArrTime) FROM mytable GROUP BY DivDistance, DestAirportSeqID, Origin LIMIT 10000"],"pql":"SELECT COUNT(DestAirportSeqID), COUNT(Diverted), MIN(CRSAr [...]
+{"hsqls":["SELECT DivReachedDest, ArrDelayMinutes, COUNT(DayOfWeek) FROM mytable GROUP BY DivReachedDest, ArrDelayMinutes LIMIT 10000","SELECT DivReachedDest, ArrDelayMinutes, COUNT(DivDistance) FROM mytable GROUP BY DivReachedDest, ArrDelayMinutes LIMIT 10000","SELECT DivReachedDest, ArrDelayMinutes, AVG(CAST(CRSArrTime AS DOUBLE)) FROM mytable GROUP BY DivReachedDest, ArrDelayMinutes LIMIT 10000"],"pql":"SELECT COUNT(DayOfWeek), COUNT(DivDistance), AVG(CRSArrTime) FROM mytable GROUP BY [...]
+{"hsqls":["SELECT DivReachedDest, COUNT(DayofMonth) FROM mytable GROUP BY DivReachedDest LIMIT 10000","SELECT DivReachedDest, MAX(AirTime) FROM mytable GROUP BY DivReachedDest LIMIT 10000"],"pql":"SELECT COUNT(DayofMonth), MAX(AirTime) FROM mytable GROUP BY DivReachedDest TOP 7"}
+{"hsqls":["SELECT Diverted, COUNT(Origin) FROM mytable GROUP BY Diverted LIMIT 10000","SELECT Diverted, COUNT(ArrDel15) FROM mytable GROUP BY Diverted LIMIT 10000","SELECT Diverted, COUNT(FlightDate) FROM mytable GROUP BY Diverted LIMIT 10000"],"pql":"SELECT COUNT(Origin), COUNT(ArrDel15), COUNT(FlightDate) FROM mytable GROUP BY Diverted TOP 5"}
+{"hsqls":["SELECT Diverted, WeatherDelay, Dest, COUNT(OriginCityMarketID) FROM mytable GROUP BY Diverted, WeatherDelay, Dest LIMIT 10000","SELECT Diverted, WeatherDelay, Dest, MAX(Distance) FROM mytable GROUP BY Diverted, WeatherDelay, Dest LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID), MAX(Distance) FROM mytable GROUP BY Diverted, WeatherDelay, Dest TOP 5"}
+{"hsqls":["SELECT FirstDepTime, COUNT(TaxiOut) FROM mytable GROUP BY FirstDepTime LIMIT 10000","SELECT FirstDepTime, MIN(CRSArrTime) FROM mytable GROUP BY FirstDepTime LIMIT 10000"],"pql":"SELECT COUNT(TaxiOut), MIN(CRSArrTime) FROM mytable GROUP BY FirstDepTime TOP 6"}
+{"hsqls":["SELECT FirstDepTime, Cancelled, ArrivalDelayGroups, COUNT(OriginAirportID) FROM mytable GROUP BY FirstDepTime, Cancelled, ArrivalDelayGroups LIMIT 10000","SELECT FirstDepTime, Cancelled, ArrivalDelayGroups, COUNT(TaxiOut) FROM mytable GROUP BY FirstDepTime, Cancelled, ArrivalDelayGroups LIMIT 10000","SELECT FirstDepTime, Cancelled, ArrivalDelayGroups, AVG(CAST(AirTime AS DOUBLE)) FROM mytable GROUP BY FirstDepTime, Cancelled, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUN [...]
+{"hsqls":["SELECT FlightDate, COUNT(FirstDepTime) FROM mytable GROUP BY FlightDate LIMIT 10000","SELECT FlightDate, MIN(DaysSinceEpoch) FROM mytable GROUP BY FlightDate LIMIT 10000","SELECT FlightDate, COUNT(OriginState) FROM mytable GROUP BY FlightDate LIMIT 10000"],"pql":"SELECT COUNT(FirstDepTime), MIN(DaysSinceEpoch), COUNT(OriginState) FROM mytable GROUP BY FlightDate TOP 23"}
+{"hsqls":["SELECT Flights, OriginStateName, COUNT(OriginAirportSeqID) FROM mytable GROUP BY Flights, OriginStateName LIMIT 10000","SELECT Flights, OriginStateName, MAX(DistanceGroup) FROM mytable GROUP BY Flights, OriginStateName LIMIT 10000","SELECT Flights, OriginStateName, SUM(CRSElapsedTime) FROM mytable GROUP BY Flights, OriginStateName LIMIT 10000"],"pql":"SELECT COUNT(OriginAirportSeqID), MAX(DistanceGroup), SUM(CRSElapsedTime) FROM mytable GROUP BY Flights, OriginStateName TOP 29"}
+{"hsqls":["SELECT LongestAddGTime, COUNT(TaxiIn) FROM mytable GROUP BY LongestAddGTime LIMIT 10000","SELECT LongestAddGTime, AVG(CAST(FlightNum AS DOUBLE)) FROM mytable GROUP BY LongestAddGTime LIMIT 10000","SELECT LongestAddGTime, MAX(TaxiOut) FROM mytable GROUP BY LongestAddGTime LIMIT 10000"],"pql":"SELECT COUNT(TaxiIn), AVG(FlightNum), MAX(TaxiOut) FROM mytable GROUP BY LongestAddGTime TOP 19"}
+{"hsqls":["SELECT OriginAirportSeqID, ArrTimeBlk, COUNT(*) FROM mytable GROUP BY OriginAirportSeqID, ArrTimeBlk LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY OriginAirportSeqID, ArrTimeBlk TOP 26"}
+{"hsqls":["SELECT OriginAirportSeqID, COUNT(OriginCityName) FROM mytable GROUP BY OriginAirportSeqID LIMIT 10000","SELECT OriginAirportSeqID, SUM(OriginStateFips) FROM mytable GROUP BY OriginAirportSeqID LIMIT 10000"],"pql":"SELECT COUNT(OriginCityName), SUM(OriginStateFips) FROM mytable GROUP BY OriginAirportSeqID TOP 12"}
+{"hsqls":["SELECT OriginStateFips, Origin, COUNT(Month) FROM mytable GROUP BY OriginStateFips, Origin LIMIT 10000","SELECT OriginStateFips, Origin, AVG(CAST(FlightNum AS DOUBLE)) FROM mytable GROUP BY OriginStateFips, Origin LIMIT 10000"],"pql":"SELECT COUNT(Month), AVG(FlightNum) FROM mytable GROUP BY OriginStateFips, Origin TOP 11"}
+{"hsqls":["SELECT Quarter, DestAirportID, COUNT(DistanceGroup) FROM mytable GROUP BY Quarter, DestAirportID LIMIT 10000","SELECT Quarter, DestAirportID, MIN(ArrivalDelayGroups) FROM mytable GROUP BY Quarter, DestAirportID LIMIT 10000"],"pql":"SELECT COUNT(DistanceGroup), MIN(ArrivalDelayGroups) FROM mytable GROUP BY Quarter, DestAirportID TOP 4"}
+{"hsqls":["SELECT Quarter, DivAirportLandings, UniqueCarrier, COUNT(DivActualElapsedTime) FROM mytable GROUP BY Quarter, DivAirportLandings, UniqueCarrier LIMIT 10000","SELECT Quarter, DivAirportLandings, UniqueCarrier, MAX(NASDelay) FROM mytable GROUP BY Quarter, DivAirportLandings, UniqueCarrier LIMIT 10000","SELECT Quarter, DivAirportLandings, UniqueCarrier, AVG(CAST(Diverted AS DOUBLE)) FROM mytable GROUP BY Quarter, DivAirportLandings, UniqueCarrier LIMIT 10000"],"pql":"SELECT COUNT [...]
+{"hsqls":["SELECT SecurityDelay, DepTimeBlk, ArrivalDelayGroups, COUNT(*) FROM mytable GROUP BY SecurityDelay, DepTimeBlk, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY SecurityDelay, DepTimeBlk, ArrivalDelayGroups TOP 28"}
+{"hsqls":["SELECT SecurityDelay, DivArrDelay, COUNT(OriginAirportSeqID) FROM mytable GROUP BY SecurityDelay, DivArrDelay LIMIT 10000","SELECT SecurityDelay, DivArrDelay, SUM(CRSArrTime) FROM mytable GROUP BY SecurityDelay, DivArrDelay LIMIT 10000","SELECT SecurityDelay, DivArrDelay, AVG(CAST(ArrDelay AS DOUBLE)) FROM mytable GROUP BY SecurityDelay, DivArrDelay LIMIT 10000"],"pql":"SELECT COUNT(OriginAirportSeqID), SUM(CRSArrTime), AVG(ArrDelay) FROM mytable GROUP BY SecurityDelay, DivArr [...]
+{"hsqls":["SELECT TailNum, COUNT(*) FROM mytable GROUP BY TailNum LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY TailNum TOP 6"}
+{"hsqls":["SELECT TailNum, COUNT(OriginWac) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, SUM(DaysSinceEpoch) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, MAX(WeatherDelay) FROM mytable GROUP BY TailNum LIMIT 10000"],"pql":"SELECT COUNT(OriginWac), SUM(DaysSinceEpoch), MAX(WeatherDelay) FROM mytable GROUP BY TailNum TOP 26"}
+{"hsqls":["SELECT TaxiIn, COUNT(DestStateName) FROM mytable GROUP BY TaxiIn LIMIT 10000","SELECT TaxiIn, SUM(OriginAirportSeqID) FROM mytable GROUP BY TaxiIn LIMIT 10000","SELECT TaxiIn, MAX(AirTime) FROM mytable GROUP BY TaxiIn LIMIT 10000"],"pql":"SELECT COUNT(DestStateName), SUM(OriginAirportSeqID), MAX(AirTime) FROM mytable GROUP BY TaxiIn TOP 10"}
+{"hsqls":["SELECT TotalAddGTime, NASDelay, CancellationCode, COUNT(*) FROM mytable GROUP BY TotalAddGTime, NASDelay, CancellationCode LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY TotalAddGTime, NASDelay, CancellationCode TOP 16"}
+{"hsqls":["SELECT UniqueCarrier, COUNT(*) FROM mytable GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY UniqueCarrier TOP 25"}
+{"hsqls":["SELECT WheelsOff, COUNT(OriginAirportSeqID) FROM mytable GROUP BY WheelsOff LIMIT 10000","SELECT WheelsOff, AVG(CAST(LongestAddGTime AS DOUBLE)) FROM mytable GROUP BY WheelsOff LIMIT 10000","SELECT WheelsOff, MIN(CRSElapsedTime) FROM mytable GROUP BY WheelsOff LIMIT 10000"],"pql":"SELECT COUNT(OriginAirportSeqID), AVG(LongestAddGTime), MIN(CRSElapsedTime) FROM mytable GROUP BY WheelsOff TOP 12"}
+{"hsqls":["SELECT Year, DestState, Flights, COUNT(DistanceGroup) FROM mytable GROUP BY Year, DestState, Flights LIMIT 10000","SELECT Year, DestState, Flights, SUM(DayOfWeek) FROM mytable GROUP BY Year, DestState, Flights LIMIT 10000","SELECT Year, DestState, Flights, MIN(TaxiOut) FROM mytable GROUP BY Year, DestState, Flights LIMIT 10000"],"pql":"SELECT COUNT(DistanceGroup), SUM(DayOfWeek), MIN(TaxiOut) FROM mytable GROUP BY Year, DestState, Flights TOP 14"}
+{"hsqls":["SELECT Year, OriginCityMarketID, COUNT(DestCityMarketID) FROM mytable GROUP BY Year, OriginCityMarketID LIMIT 10000","SELECT Year, OriginCityMarketID, AVG(CAST(DistanceGroup AS DOUBLE)) FROM mytable GROUP BY Year, OriginCityMarketID LIMIT 10000"],"pql":"SELECT COUNT(DestCityMarketID), AVG(DistanceGroup) FROM mytable GROUP BY Year, OriginCityMarketID TOP 5"}
+
+{"hsqls":["SELECT ActualElapsedTime, DepDel15, MAX(OriginAirportID) FROM mytable GROUP BY ActualElapsedTime, DepDel15 LIMIT 10000","SELECT ActualElapsedTime, DepDel15, MAX(FlightNum) FROM mytable GROUP BY ActualElapsedTime, DepDel15 LIMIT 10000"],"pql":"SELECT MAX(OriginAirportID), MAX(FlightNum) FROM mytable GROUP BY ActualElapsedTime, DepDel15 TOP 27"}
+{"hsqls":["SELECT AirTime, MAX(DivDistance) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, SUM(DayOfWeek) FROM mytable GROUP BY AirTime LIMIT 10000"],"pql":"SELECT MAX(DivDistance), SUM(DayOfWeek) FROM mytable GROUP BY AirTime TOP 22"}
+{"hsqls":["SELECT AirlineID, MAX(OriginAirportSeqID) FROM mytable GROUP BY AirlineID LIMIT 10000","SELECT AirlineID, MAX(DepartureDelayGroups) FROM mytable GROUP BY AirlineID LIMIT 10000"],"pql":"SELECT MAX(OriginAirportSeqID), MAX(DepartureDelayGroups) FROM mytable GROUP BY AirlineID TOP 7"}
+{"hsqls":["SELECT ArrDelay, DivArrDelay, MAX(Cancelled) FROM mytable GROUP BY ArrDelay, DivArrDelay LIMIT 10000"],"pql":"SELECT MAX(Cancelled) FROM mytable GROUP BY ArrDelay, DivArrDelay TOP 26"}
+{"hsqls":["SELECT ArrDelayMinutes, MAX(DistanceGroup) FROM mytable GROUP BY ArrDelayMinutes LIMIT 10000","SELECT ArrDelayMinutes, MIN(CarrierDelay) FROM mytable GROUP BY ArrDelayMinutes LIMIT 10000"],"pql":"SELECT MAX(DistanceGroup), MIN(CarrierDelay) FROM mytable GROUP BY ArrDelayMinutes TOP 15"}
+{"hsqls":["SELECT ArrTime, MAX(DepTime) FROM mytable GROUP BY ArrTime LIMIT 10000","SELECT ArrTime, SUM(ArrivalDelayGroups) FROM mytable GROUP BY ArrTime LIMIT 10000","SELECT ArrTime, SUM(DepDelayMinutes) FROM mytable GROUP BY ArrTime LIMIT 10000"],"pql":"SELECT MAX(DepTime), SUM(ArrivalDelayGroups), SUM(DepDelayMinutes) FROM mytable GROUP BY ArrTime TOP 24"}
+{"hsqls":["SELECT CarrierDelay, MAX(DestCityMarketID) FROM mytable GROUP BY CarrierDelay LIMIT 10000","SELECT CarrierDelay, SUM(DivDistance) FROM mytable GROUP BY CarrierDelay LIMIT 10000","SELECT CarrierDelay, COUNT(DivAirportLandings) FROM mytable GROUP BY CarrierDelay LIMIT 10000"],"pql":"SELECT MAX(DestCityMarketID), SUM(DivDistance), COUNT(DivAirportLandings) FROM mytable GROUP BY CarrierDelay TOP 27"}
+{"hsqls":["SELECT DayofMonth, DivAirportLandings, MAX(WheelsOff) FROM mytable GROUP BY DayofMonth, DivAirportLandings LIMIT 10000","SELECT DayofMonth, DivAirportLandings, MAX(OriginAirportID) FROM mytable GROUP BY DayofMonth, DivAirportLandings LIMIT 10000"],"pql":"SELECT MAX(WheelsOff), MAX(OriginAirportID) FROM mytable GROUP BY DayofMonth, DivAirportLandings TOP 9"}
+{"hsqls":["SELECT DayofMonth, MAX(DestStateFips) FROM mytable GROUP BY DayofMonth LIMIT 10000","SELECT DayofMonth, MIN(DivDistance) FROM mytable GROUP BY DayofMonth LIMIT 10000","SELECT DayofMonth, MAX(LateAircraftDelay) FROM mytable GROUP BY DayofMonth LIMIT 10000"],"pql":"SELECT MAX(DestStateFips), MIN(DivDistance), MAX(LateAircraftDelay) FROM mytable GROUP BY DayofMonth TOP 21"}
+{"hsqls":["SELECT DaysSinceEpoch, MAX(ArrDelayMinutes) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000"],"pql":"SELECT MAX(ArrDelayMinutes) FROM mytable GROUP BY DaysSinceEpoch TOP 26"}
+{"hsqls":["SELECT DepDel15, MAX(DepDelayMinutes) FROM mytable GROUP BY DepDel15 LIMIT 10000","SELECT DepDel15, SUM(DivArrDelay) FROM mytable GROUP BY DepDel15 LIMIT 10000","SELECT DepDel15, SUM(Quarter) FROM mytable GROUP BY DepDel15 LIMIT 10000"],"pql":"SELECT MAX(DepDelayMinutes), SUM(DivArrDelay), SUM(Quarter) FROM mytable GROUP BY DepDel15 TOP 23"}
+{"hsqls":["SELECT DepDelay, DestStateFips, Cancelled, MAX(TaxiIn) FROM mytable GROUP BY DepDelay, DestStateFips, Cancelled LIMIT 10000"],"pql":"SELECT MAX(TaxiIn) FROM mytable GROUP BY DepDelay, DestStateFips, Cancelled TOP 20"}
+{"hsqls":["SELECT DepTime, MAX(AirlineID) FROM mytable GROUP BY DepTime LIMIT 10000","SELECT DepTime, SUM(WheelsOff) FROM mytable GROUP BY DepTime LIMIT 10000","SELECT DepTime, AVG(CAST(WheelsOn AS DOUBLE)) FROM mytable GROUP BY DepTime LIMIT 10000"],"pql":"SELECT MAX(AirlineID), SUM(WheelsOff), AVG(WheelsOn) FROM mytable GROUP BY DepTime TOP 16"}
+{"hsqls":["SELECT DepTimeBlk, MAX(DepDel15) FROM mytable GROUP BY DepTimeBlk LIMIT 10000","SELECT DepTimeBlk, MIN(Cancelled) FROM mytable GROUP BY DepTimeBlk LIMIT 10000"],"pql":"SELECT MAX(DepDel15), MIN(Cancelled) FROM mytable GROUP BY DepTimeBlk TOP 16"}
+{"hsqls":["SELECT DestCityName, MAX(ArrDel15) FROM mytable GROUP BY DestCityName LIMIT 10000","SELECT DestCityName, COUNT(FlightDate) FROM mytable GROUP BY DestCityName LIMIT 10000"],"pql":"SELECT MAX(ArrDel15), COUNT(FlightDate) FROM mytable GROUP BY DestCityName TOP 27"}
+{"hsqls":["SELECT DivReachedDest, ArrivalDelayGroups, MAX(TaxiIn) FROM mytable GROUP BY DivReachedDest, ArrivalDelayGroups LIMIT 10000","SELECT DivReachedDest, ArrivalDelayGroups, AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable GROUP BY DivReachedDest, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT MAX(TaxiIn), AVG(OriginStateFips) FROM mytable GROUP BY DivReachedDest, ArrivalDelayGroups TOP 15"}
+{"hsqls":["SELECT DivReachedDest, Distance, MAX(LongestAddGTime) FROM mytable GROUP BY DivReachedDest, Distance LIMIT 10000","SELECT DivReachedDest, Distance, SUM(DestAirportID) FROM mytable GROUP BY DivReachedDest, Distance LIMIT 10000","SELECT DivReachedDest, Distance, SUM(Distance) FROM mytable GROUP BY DivReachedDest, Distance LIMIT 10000"],"pql":"SELECT MAX(LongestAddGTime), SUM(DestAirportID), SUM(Distance) FROM mytable GROUP BY DivReachedDest, Distance TOP 11"}
+{"hsqls":["SELECT Diverted, DestState, DepDel15, MAX(DistanceGroup) FROM mytable GROUP BY Diverted, DestState, DepDel15 LIMIT 10000","SELECT Diverted, DestState, DepDel15, AVG(CAST(FirstDepTime AS DOUBLE)) FROM mytable GROUP BY Diverted, DestState, DepDel15 LIMIT 10000"],"pql":"SELECT MAX(DistanceGroup), AVG(FirstDepTime) FROM mytable GROUP BY Diverted, DestState, DepDel15 TOP 11"}
+{"hsqls":["SELECT Diverted, DestStateFips, MAX(TaxiOut) FROM mytable GROUP BY Diverted, DestStateFips LIMIT 10000","SELECT Diverted, DestStateFips, AVG(CAST(DepTime AS DOUBLE)) FROM mytable GROUP BY Diverted, DestStateFips LIMIT 10000"],"pql":"SELECT MAX(TaxiOut), AVG(DepTime) FROM mytable GROUP BY Diverted, DestStateFips TOP 3"}
+{"hsqls":["SELECT FirstDepTime, ArrDel15, MAX(AirlineID) FROM mytable GROUP BY FirstDepTime, ArrDel15 LIMIT 10000"],"pql":"SELECT MAX(AirlineID) FROM mytable GROUP BY FirstDepTime, ArrDel15 TOP 18"}
+{"hsqls":["SELECT FlightNum, MAX(ArrDel15) FROM mytable GROUP BY FlightNum LIMIT 10000","SELECT FlightNum, SUM(TaxiOut) FROM mytable GROUP BY FlightNum LIMIT 10000","SELECT FlightNum, MAX(TaxiIn) FROM mytable GROUP BY FlightNum LIMIT 10000"],"pql":"SELECT MAX(ArrDel15), SUM(TaxiOut), MAX(TaxiIn) FROM mytable GROUP BY FlightNum"}
+{"hsqls":["SELECT Flights, CRSDepTime, MAX(Flights) FROM mytable GROUP BY Flights, CRSDepTime LIMIT 10000","SELECT Flights, CRSDepTime, SUM(LateAircraftDelay) FROM mytable GROUP BY Flights, CRSDepTime LIMIT 10000","SELECT Flights, CRSDepTime, MAX(SecurityDelay) FROM mytable GROUP BY Flights, CRSDepTime LIMIT 10000"],"pql":"SELECT MAX(Flights), SUM(LateAircraftDelay), MAX(SecurityDelay) FROM mytable GROUP BY Flights, CRSDepTime TOP 8"}
+{"hsqls":["SELECT Flights, TaxiIn, DestCityMarketID, MAX(DaysSinceEpoch) FROM mytable GROUP BY Flights, TaxiIn, DestCityMarketID LIMIT 10000","SELECT Flights, TaxiIn, DestCityMarketID, AVG(CAST(ArrDelayMinutes AS DOUBLE)) FROM mytable GROUP BY Flights, TaxiIn, DestCityMarketID LIMIT 10000","SELECT Flights, TaxiIn, DestCityMarketID, SUM(DepTime) FROM mytable GROUP BY Flights, TaxiIn, DestCityMarketID LIMIT 10000"],"pql":"SELECT MAX(DaysSinceEpoch), AVG(ArrDelayMinutes), SUM(DepTime) FROM [...]
+{"hsqls":["SELECT LateAircraftDelay, MAX(ArrDel15) FROM mytable GROUP BY LateAircraftDelay LIMIT 10000","SELECT LateAircraftDelay, COUNT(ActualElapsedTime) FROM mytable GROUP BY LateAircraftDelay LIMIT 10000","SELECT LateAircraftDelay, MIN(LongestAddGTime) FROM mytable GROUP BY LateAircraftDelay LIMIT 10000"],"pql":"SELECT MAX(ArrDel15), COUNT(ActualElapsedTime), MIN(LongestAddGTime) FROM mytable GROUP BY LateAircraftDelay TOP 17"}
+{"hsqls":["SELECT LongestAddGTime, OriginStateName, MAX(OriginAirportSeqID) FROM mytable GROUP BY LongestAddGTime, OriginStateName LIMIT 10000","SELECT LongestAddGTime, OriginStateName, COUNT(NASDelay) FROM mytable GROUP BY LongestAddGTime, OriginStateName LIMIT 10000","SELECT LongestAddGTime, OriginStateName, AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable GROUP BY LongestAddGTime, OriginStateName LIMIT 10000"],"pql":"SELECT MAX(OriginAirportSeqID), COUNT(NASDelay), AVG(OriginStateFip [...]
+{"hsqls":["SELECT OriginAirportID, MAX(TaxiIn) FROM mytable GROUP BY OriginAirportID LIMIT 10000","SELECT OriginAirportID, COUNT(DaysSinceEpoch) FROM mytable GROUP BY OriginAirportID LIMIT 10000"],"pql":"SELECT MAX(TaxiIn), COUNT(DaysSinceEpoch) FROM mytable GROUP BY OriginAirportID TOP 8"}
+{"hsqls":["SELECT OriginAirportSeqID, MAX(Flights) FROM mytable GROUP BY OriginAirportSeqID LIMIT 10000","SELECT OriginAirportSeqID, MIN(FlightNum) FROM mytable GROUP BY OriginAirportSeqID LIMIT 10000"],"pql":"SELECT MAX(Flights), MIN(FlightNum) FROM mytable GROUP BY OriginAirportSeqID TOP 8"}
+{"hsqls":["SELECT OriginCityMarketID, ArrTimeBlk, AirlineID, MAX(DestCityMarketID) FROM mytable GROUP BY OriginCityMarketID, ArrTimeBlk, AirlineID LIMIT 10000","SELECT OriginCityMarketID, ArrTimeBlk, AirlineID, MAX(AirTime) FROM mytable GROUP BY OriginCityMarketID, ArrTimeBlk, AirlineID LIMIT 10000"],"pql":"SELECT MAX(DestCityMarketID), MAX(AirTime) FROM mytable GROUP BY OriginCityMarketID, ArrTimeBlk, AirlineID TOP 15"}
+{"hsqls":["SELECT OriginStateFips, DivAirportLandings, MAX(ArrivalDelayGroups) FROM mytable GROUP BY OriginStateFips, DivAirportLandings LIMIT 10000","SELECT OriginStateFips, DivAirportLandings, MAX(CRSElapsedTime) FROM mytable GROUP BY OriginStateFips, DivAirportLandings LIMIT 10000"],"pql":"SELECT MAX(ArrivalDelayGroups), MAX(CRSElapsedTime) FROM mytable GROUP BY OriginStateFips, DivAirportLandings TOP 10"}
+{"hsqls":["SELECT OriginWac, DayOfWeek, MAX(DestAirportID) FROM mytable GROUP BY OriginWac, DayOfWeek LIMIT 10000","SELECT OriginWac, DayOfWeek, MAX(CarrierDelay) FROM mytable GROUP BY OriginWac, DayOfWeek LIMIT 10000"],"pql":"SELECT MAX(DestAirportID), MAX(CarrierDelay) FROM mytable GROUP BY OriginWac, DayOfWeek TOP 16"}
+{"hsqls":["SELECT Quarter, FirstDepTime, OriginStateName, MAX(DepDel15) FROM mytable GROUP BY Quarter, FirstDepTime, OriginStateName LIMIT 10000","SELECT Quarter, FirstDepTime, OriginStateName, SUM(CRSElapsedTime) FROM mytable GROUP BY Quarter, FirstDepTime, OriginStateName LIMIT 10000"],"pql":"SELECT MAX(DepDel15), SUM(CRSElapsedTime) FROM mytable GROUP BY Quarter, FirstDepTime, OriginStateName TOP 2"}
+{"hsqls":["SELECT TaxiOut, MAX(DestStateFips) FROM mytable GROUP BY TaxiOut LIMIT 10000","SELECT TaxiOut, AVG(CAST(DestCityMarketID AS DOUBLE)) FROM mytable GROUP BY TaxiOut LIMIT 10000"],"pql":"SELECT MAX(DestStateFips), AVG(DestCityMarketID) FROM mytable GROUP BY TaxiOut TOP 4"}
+{"hsqls":["SELECT TotalAddGTime, ArrTime, MAX(ArrDelayMinutes) FROM mytable GROUP BY TotalAddGTime, ArrTime LIMIT 10000","SELECT TotalAddGTime, ArrTime, MAX(WeatherDelay) FROM mytable GROUP BY TotalAddGTime, ArrTime LIMIT 10000"],"pql":"SELECT MAX(ArrDelayMinutes), MAX(WeatherDelay) FROM mytable GROUP BY TotalAddGTime, ArrTime TOP 27"}
+{"hsqls":["SELECT TotalAddGTime, MAX(ArrivalDelayGroups) FROM mytable GROUP BY TotalAddGTime LIMIT 10000","SELECT TotalAddGTime, SUM(DestAirportID) FROM mytable GROUP BY TotalAddGTime LIMIT 10000"],"pql":"SELECT MAX(ArrivalDelayGroups), SUM(DestAirportID) FROM mytable GROUP BY TotalAddGTime TOP 29"}
+{"hsqls":["SELECT UniqueCarrier, MAX(Year) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, COUNT(OriginState) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, AVG(CAST(OriginAirportID AS DOUBLE)) FROM mytable GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT MAX(Year), COUNT(OriginState), AVG(OriginAirportID) FROM mytable GROUP BY UniqueCarrier TOP 16"}
+{"hsqls":["SELECT WeatherDelay, Origin, OriginWac, MAX(WheelsOff) FROM mytable GROUP BY WeatherDelay, Origin, OriginWac LIMIT 10000","SELECT WeatherDelay, Origin, OriginWac, MAX(ArrDelayMinutes) FROM mytable GROUP BY WeatherDelay, Origin, OriginWac LIMIT 10000"],"pql":"SELECT MAX(WheelsOff), MAX(ArrDelayMinutes) FROM mytable GROUP BY WeatherDelay, Origin, OriginWac TOP 7"}
+
+{"hsqls":["SELECT AirTime, MIN(AirTime) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, MIN(CRSDepTime) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, AVG(CAST(ArrDelay AS DOUBLE)) FROM mytable GROUP BY AirTime LIMIT 10000"],"pql":"SELECT MIN(AirTime), MIN(CRSDepTime), AVG(ArrDelay) FROM mytable GROUP BY AirTime TOP 18"}
+{"hsqls":["SELECT AirlineID, MIN(ArrDelayMinutes) FROM mytable GROUP BY AirlineID LIMIT 10000","SELECT AirlineID, AVG(CAST(ActualElapsedTime AS DOUBLE)) FROM mytable GROUP BY AirlineID LIMIT 10000"],"pql":"SELECT MIN(ArrDelayMinutes), AVG(ActualElapsedTime) FROM mytable GROUP BY AirlineID TOP 10"}
+{"hsqls":["SELECT ArrDel15, MIN(DestAirportSeqID) FROM mytable GROUP BY ArrDel15 LIMIT 10000","SELECT ArrDel15, COUNT(Distance) FROM mytable GROUP BY ArrDel15 LIMIT 10000"],"pql":"SELECT MIN(DestAirportSeqID), COUNT(Distance) FROM mytable GROUP BY ArrDel15 TOP 7"}
+{"hsqls":["SELECT ArrTime, MIN(DepDelayMinutes) FROM mytable GROUP BY ArrTime LIMIT 10000","SELECT ArrTime, COUNT(OriginAirportSeqID) FROM mytable GROUP BY ArrTime LIMIT 10000","SELECT ArrTime, MAX(DivReachedDest) FROM mytable GROUP BY ArrTime LIMIT 10000"],"pql":"SELECT MIN(DepDelayMinutes), COUNT(OriginAirportSeqID), MAX(DivReachedDest) FROM mytable GROUP BY ArrTime TOP 7"}
+{"hsqls":["SELECT CancellationCode, ArrivalDelayGroups, MIN(Cancelled) FROM mytable GROUP BY CancellationCode, ArrivalDelayGroups LIMIT 10000","SELECT CancellationCode, ArrivalDelayGroups, SUM(OriginAirportSeqID) FROM mytable GROUP BY CancellationCode, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT MIN(Cancelled), SUM(OriginAirportSeqID) FROM mytable GROUP BY CancellationCode, ArrivalDelayGroups TOP 25"}
+{"hsqls":["SELECT Cancelled, DestStateName, MIN(DepDel15) FROM mytable GROUP BY Cancelled, DestStateName LIMIT 10000","SELECT Cancelled, DestStateName, MIN(ArrTime) FROM mytable GROUP BY Cancelled, DestStateName LIMIT 10000","SELECT Cancelled, DestStateName, SUM(TaxiIn) FROM mytable GROUP BY Cancelled, DestStateName LIMIT 10000"],"pql":"SELECT MIN(DepDel15), MIN(ArrTime), SUM(TaxiIn) FROM mytable GROUP BY Cancelled, DestStateName TOP 29"}
+{"hsqls":["SELECT Dest, MIN(DivActualElapsedTime) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, MAX(Year) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, COUNT(OriginWac) FROM mytable GROUP BY Dest LIMIT 10000"],"pql":"SELECT MIN(DivActualElapsedTime), MAX(Year), COUNT(OriginWac) FROM mytable GROUP BY Dest TOP 29"}
+{"hsqls":["SELECT DestAirportID, MIN(DepartureDelayGroups) FROM mytable GROUP BY DestAirportID LIMIT 10000","SELECT DestAirportID, COUNT(DivDistance) FROM mytable GROUP BY DestAirportID LIMIT 10000"],"pql":"SELECT MIN(DepartureDelayGroups), COUNT(DivDistance) FROM mytable GROUP BY DestAirportID TOP 6"}
+{"hsqls":["SELECT DestState, MIN(DaysSinceEpoch) FROM mytable GROUP BY DestState LIMIT 10000","SELECT DestState, COUNT(NASDelay) FROM mytable GROUP BY DestState LIMIT 10000","SELECT DestState, COUNT(DepDelayMinutes) FROM mytable GROUP BY DestState LIMIT 10000"],"pql":"SELECT MIN(DaysSinceEpoch), COUNT(NASDelay), COUNT(DepDelayMinutes) FROM mytable GROUP BY DestState TOP 10"}
+{"hsqls":["SELECT DestStateFips, DestCityName, DestAirportID, MIN(AirlineID) FROM mytable GROUP BY DestStateFips, DestCityName, DestAirportID LIMIT 10000"],"pql":"SELECT MIN(AirlineID) FROM mytable GROUP BY DestStateFips, DestCityName, DestAirportID TOP 25"}
+{"hsqls":["SELECT DestWac, OriginStateFips, MIN(ArrDelayMinutes) FROM mytable GROUP BY DestWac, OriginStateFips LIMIT 10000","SELECT DestWac, OriginStateFips, SUM(FirstDepTime) FROM mytable GROUP BY DestWac, OriginStateFips LIMIT 10000","SELECT DestWac, OriginStateFips, MIN(DepDelay) FROM mytable GROUP BY DestWac, OriginStateFips LIMIT 10000"],"pql":"SELECT MIN(ArrDelayMinutes), SUM(FirstDepTime), MIN(DepDelay) FROM mytable GROUP BY DestWac, OriginStateFips TOP 17"}
+{"hsqls":["SELECT Distance, OriginWac, MIN(CRSElapsedTime) FROM mytable GROUP BY Distance, OriginWac LIMIT 10000","SELECT Distance, OriginWac, MIN(FirstDepTime) FROM mytable GROUP BY Distance, OriginWac LIMIT 10000"],"pql":"SELECT MIN(CRSElapsedTime), MIN(FirstDepTime) FROM mytable GROUP BY Distance, OriginWac TOP 24"}
+{"hsqls":["SELECT DistanceGroup, Cancelled, CRSElapsedTime, MIN(DivDistance) FROM mytable GROUP BY DistanceGroup, Cancelled, CRSElapsedTime LIMIT 10000","SELECT DistanceGroup, Cancelled, CRSElapsedTime, MIN(ArrDel15) FROM mytable GROUP BY DistanceGroup, Cancelled, CRSElapsedTime LIMIT 10000"],"pql":"SELECT MIN(DivDistance), MIN(ArrDel15) FROM mytable GROUP BY DistanceGroup, Cancelled, CRSElapsedTime TOP 23"}
+{"hsqls":["SELECT Flights, DestCityMarketID, DivArrDelay, MIN(ArrDelayMinutes) FROM mytable GROUP BY Flights, DestCityMarketID, DivArrDelay LIMIT 10000","SELECT Flights, DestCityMarketID, DivArrDelay, SUM(Month) FROM mytable GROUP BY Flights, DestCityMarketID, DivArrDelay LIMIT 10000","SELECT Flights, DestCityMarketID, DivArrDelay, SUM(Quarter) FROM mytable GROUP BY Flights, DestCityMarketID, DivArrDelay LIMIT 10000"],"pql":"SELECT MIN(ArrDelayMinutes), SUM(Month), SUM(Quarter) FROM myta [...]
+{"hsqls":["SELECT LateAircraftDelay, MIN(Year) FROM mytable GROUP BY LateAircraftDelay LIMIT 10000","SELECT LateAircraftDelay, SUM(DistanceGroup) FROM mytable GROUP BY LateAircraftDelay LIMIT 10000"],"pql":"SELECT MIN(Year), SUM(DistanceGroup) FROM mytable GROUP BY LateAircraftDelay TOP 1"}
+{"hsqls":["SELECT LongestAddGTime, MIN(ActualElapsedTime) FROM mytable GROUP BY LongestAddGTime LIMIT 10000","SELECT LongestAddGTime, AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable GROUP BY LongestAddGTime LIMIT 10000"],"pql":"SELECT MIN(ActualElapsedTime), AVG(OriginStateFips) FROM mytable GROUP BY LongestAddGTime TOP 16"}
+{"hsqls":["SELECT NASDelay, DayOfWeek, MIN(ActualElapsedTime) FROM mytable GROUP BY NASDelay, DayOfWeek LIMIT 10000"],"pql":"SELECT MIN(ActualElapsedTime) FROM mytable GROUP BY NASDelay, DayOfWeek TOP 1"}
+{"hsqls":["SELECT OriginAirportID, MIN(DivActualElapsedTime) FROM mytable GROUP BY OriginAirportID LIMIT 10000","SELECT OriginAirportID, MIN(LateAircraftDelay) FROM mytable GROUP BY OriginAirportID LIMIT 10000","SELECT OriginAirportID, MAX(ArrDelayMinutes) FROM mytable GROUP BY OriginAirportID LIMIT 10000"],"pql":"SELECT MIN(DivActualElapsedTime), MIN(LateAircraftDelay), MAX(ArrDelayMinutes) FROM mytable GROUP BY OriginAirportID TOP 27"}
+{"hsqls":["SELECT OriginState, MIN(DestAirportID) FROM mytable GROUP BY OriginState LIMIT 10000","SELECT OriginState, MIN(DepartureDelayGroups) FROM mytable GROUP BY OriginState LIMIT 10000"],"pql":"SELECT MIN(DestAirportID), MIN(DepartureDelayGroups) FROM mytable GROUP BY OriginState TOP 14"}
+{"hsqls":["SELECT OriginState, MIN(DestCityMarketID) FROM mytable GROUP BY OriginState LIMIT 10000","SELECT OriginState, MAX(DestCityMarketID) FROM mytable GROUP BY OriginState LIMIT 10000","SELECT OriginState, COUNT(ArrDel15) FROM mytable GROUP BY OriginState LIMIT 10000"],"pql":"SELECT MIN(DestCityMarketID), MAX(DestCityMarketID), COUNT(ArrDel15) FROM mytable GROUP BY OriginState TOP 6"}
+{"hsqls":["SELECT SecurityDelay, MIN(FlightNum) FROM mytable GROUP BY SecurityDelay LIMIT 10000","SELECT SecurityDelay, SUM(DaysSinceEpoch) FROM mytable GROUP BY SecurityDelay LIMIT 10000"],"pql":"SELECT MIN(FlightNum), SUM(DaysSinceEpoch) FROM mytable GROUP BY SecurityDelay TOP 17"}
+{"hsqls":["SELECT TaxiIn, DepDel15, MIN(Year) FROM mytable GROUP BY TaxiIn, DepDel15 LIMIT 10000","SELECT TaxiIn, DepDel15, AVG(CAST(Distance AS DOUBLE)) FROM mytable GROUP BY TaxiIn, DepDel15 LIMIT 10000","SELECT TaxiIn, DepDel15, MIN(CRSArrTime) FROM mytable GROUP BY TaxiIn, DepDel15 LIMIT 10000"],"pql":"SELECT MIN(Year), AVG(Distance), MIN(CRSArrTime) FROM mytable GROUP BY TaxiIn, DepDel15 TOP 24"}
+{"hsqls":["SELECT TaxiIn, MIN(FlightNum) FROM mytable GROUP BY TaxiIn LIMIT 10000","SELECT TaxiIn, AVG(CAST(NASDelay AS DOUBLE)) FROM mytable GROUP BY TaxiIn LIMIT 10000","SELECT TaxiIn, AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable GROUP BY TaxiIn LIMIT 10000"],"pql":"SELECT MIN(FlightNum), AVG(NASDelay), AVG(LateAircraftDelay) FROM mytable GROUP BY TaxiIn TOP 29"}
+{"hsqls":["SELECT TaxiOut, TotalAddGTime, MIN(Diverted) FROM mytable GROUP BY TaxiOut, TotalAddGTime LIMIT 10000","SELECT TaxiOut, TotalAddGTime, AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable GROUP BY TaxiOut, TotalAddGTime LIMIT 10000"],"pql":"SELECT MIN(Diverted), AVG(OriginStateFips) FROM mytable GROUP BY TaxiOut, TotalAddGTime TOP 26"}
+{"hsqls":["SELECT TotalAddGTime, ArrDelay, MIN(CRSElapsedTime) FROM mytable GROUP BY TotalAddGTime, ArrDelay LIMIT 10000"],"pql":"SELECT MIN(CRSElapsedTime) FROM mytable GROUP BY TotalAddGTime, ArrDelay TOP 4"}
+{"hsqls":["SELECT UniqueCarrier, MIN(Year) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, COUNT(OriginStateName) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, SUM(DivActualElapsedTime) FROM mytable GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT MIN(Year), COUNT(OriginStateName), SUM(DivActualElapsedTime) FROM mytable GROUP BY UniqueCarrier TOP 3"}
+{"hsqls":["SELECT WeatherDelay, TotalAddGTime, UniqueCarrier, MIN(ArrDelayMinutes) FROM mytable GROUP BY WeatherDelay, TotalAddGTime, UniqueCarrier LIMIT 10000","SELECT WeatherDelay, TotalAddGTime, UniqueCarrier, AVG(CAST(DepDel15 AS DOUBLE)) FROM mytable GROUP BY WeatherDelay, TotalAddGTime, UniqueCarrier LIMIT 10000","SELECT WeatherDelay, TotalAddGTime, UniqueCarrier, SUM(DestWac) FROM mytable GROUP BY WeatherDelay, TotalAddGTime, UniqueCarrier LIMIT 10000"],"pql":"SELECT MIN(ArrDelayM [...]
+{"hsqls":["SELECT WheelsOff, Flights, DivAirportLandings, MIN(DepDelayMinutes) FROM mytable GROUP BY WheelsOff, Flights, DivAirportLandings LIMIT 10000","SELECT WheelsOff, Flights, DivAirportLandings, MIN(DepDel15) FROM mytable GROUP BY WheelsOff, Flights, DivAirportLandings LIMIT 10000"],"pql":"SELECT MIN(DepDelayMinutes), MIN(DepDel15) FROM mytable GROUP BY WheelsOff, Flights, DivAirportLandings TOP 21"}
+{"hsqls":["SELECT WheelsOn, MIN(Cancelled) FROM mytable GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, COUNT(AirTime) FROM mytable GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, MAX(ActualElapsedTime) FROM mytable GROUP BY WheelsOn LIMIT 10000"],"pql":"SELECT MIN(Cancelled), COUNT(AirTime), MAX(ActualElapsedTime) FROM mytable GROUP BY WheelsOn TOP 12"}
+{"hsqls":["SELECT WheelsOn, MIN(OriginAirportSeqID) FROM mytable GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, SUM(DepDelay) FROM mytable GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, SUM(DepartureDelayGroups) FROM mytable GROUP BY WheelsOn LIMIT 10000"],"pql":"SELECT MIN(OriginAirportSeqID), SUM(DepDelay), SUM(DepartureDelayGroups) FROM mytable GROUP BY WheelsOn TOP 6"}
+{"hsqls":["SELECT Year, Cancelled, MIN(ActualElapsedTime) FROM mytable GROUP BY Year, Cancelled LIMIT 10000","SELECT Year, Cancelled, MAX(DayofMonth) FROM mytable GROUP BY Year, Cancelled LIMIT 10000","SELECT Year, Cancelled, MIN(ArrTime) FROM mytable GROUP BY Year, Cancelled LIMIT 10000"],"pql":"SELECT MIN(ActualElapsedTime), MAX(DayofMonth), MIN(ArrTime) FROM mytable GROUP BY Year, Cancelled"}
+{"hsqls":["SELECT Year, DestStateName, MIN(CRSDepTime) FROM mytable GROUP BY Year, DestStateName LIMIT 10000","SELECT Year, DestStateName, AVG(CAST(TaxiIn AS DOUBLE)) FROM mytable GROUP BY Year, DestStateName LIMIT 10000"],"pql":"SELECT MIN(CRSDepTime), AVG(TaxiIn) FROM mytable GROUP BY Year, DestStateName TOP 10"}
+
+{"hsqls":["SELECT ActualElapsedTime, DestStateName, DivAirportLandings, SUM(DivReachedDest) FROM mytable GROUP BY ActualElapsedTime, DestStateName, DivAirportLandings LIMIT 10000","SELECT ActualElapsedTime, DestStateName, DivAirportLandings, COUNT(WheelsOff) FROM mytable GROUP BY ActualElapsedTime, DestStateName, DivAirportLandings LIMIT 10000"],"pql":"SELECT SUM(DivReachedDest), COUNT(WheelsOff) FROM mytable GROUP BY ActualElapsedTime, DestStateName, DivAirportLandings TOP 24"}
+{"hsqls":["SELECT ActualElapsedTime, SUM(TotalAddGTime) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000","SELECT ActualElapsedTime, MAX(DivReachedDest) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000","SELECT ActualElapsedTime, AVG(CAST(ArrDelay AS DOUBLE)) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000"],"pql":"SELECT SUM(TotalAddGTime), MAX(DivReachedDest), AVG(ArrDelay) FROM mytable GROUP BY ActualElapsedTime TOP 1"}
+{"hsqls":["SELECT AirTime, SUM(WeatherDelay) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, AVG(CAST(Quarter AS DOUBLE)) FROM mytable GROUP BY AirTime LIMIT 10000"],"pql":"SELECT SUM(WeatherDelay), AVG(Quarter) FROM mytable GROUP BY AirTime TOP 11"}
+{"hsqls":["SELECT AirlineID, SUM(DistanceGroup) FROM mytable GROUP BY AirlineID LIMIT 10000","SELECT AirlineID, MIN(DestAirportSeqID) FROM mytable GROUP BY AirlineID LIMIT 10000"],"pql":"SELECT SUM(DistanceGroup), MIN(DestAirportSeqID) FROM mytable GROUP BY AirlineID TOP 21"}
+{"hsqls":["SELECT ArrDelayMinutes, DivAirportLandings, SUM(DistanceGroup) FROM mytable GROUP BY ArrDelayMinutes, DivAirportLandings LIMIT 10000","SELECT ArrDelayMinutes, DivAirportLandings, COUNT(AirTime) FROM mytable GROUP BY ArrDelayMinutes, DivAirportLandings LIMIT 10000"],"pql":"SELECT SUM(DistanceGroup), COUNT(AirTime) FROM mytable GROUP BY ArrDelayMinutes, DivAirportLandings TOP 29"}
+{"hsqls":["SELECT ArrivalDelayGroups, SUM(FirstDepTime) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, MIN(DivAirportLandings) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT SUM(FirstDepTime), MIN(DivAirportLandings) FROM mytable GROUP BY ArrivalDelayGroups TOP 10"}
+{"hsqls":["SELECT Cancelled, SUM(DepDel15) FROM mytable GROUP BY Cancelled LIMIT 10000","SELECT Cancelled, MIN(DivDistance) FROM mytable GROUP BY Cancelled LIMIT 10000"],"pql":"SELECT SUM(DepDel15), MIN(DivDistance) FROM mytable GROUP BY Cancelled TOP 5"}
+{"hsqls":["SELECT Carrier, Flights, DestCityMarketID, SUM(DepDelay) FROM mytable GROUP BY Carrier, Flights, DestCityMarketID LIMIT 10000"],"pql":"SELECT SUM(DepDelay) FROM mytable GROUP BY Carrier, Flights, DestCityMarketID TOP 13"}
+{"hsqls":["SELECT DayofMonth, CancellationCode, Month, SUM(TaxiOut) FROM mytable GROUP BY DayofMonth, CancellationCode, Month LIMIT 10000","SELECT DayofMonth, CancellationCode, Month, SUM(FlightNum) FROM mytable GROUP BY DayofMonth, CancellationCode, Month LIMIT 10000"],"pql":"SELECT SUM(TaxiOut), SUM(FlightNum) FROM mytable GROUP BY DayofMonth, CancellationCode, Month TOP 19"}
+{"hsqls":["SELECT DaysSinceEpoch, SUM(DepTime) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000"],"pql":"SELECT SUM(DepTime) FROM mytable GROUP BY DaysSinceEpoch TOP 18"}
+{"hsqls":["SELECT DepDelayMinutes, SUM(DivAirportLandings) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000","SELECT DepDelayMinutes, MIN(OriginAirportID) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000","SELECT DepDelayMinutes, COUNT(AirlineID) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000"],"pql":"SELECT SUM(DivAirportLandings), MIN(OriginAirportID), COUNT(AirlineID) FROM mytable GROUP BY DepDelayMinutes TOP 4"}
+{"hsqls":["SELECT DepTimeBlk, SUM(TaxiOut) FROM mytable GROUP BY DepTimeBlk LIMIT 10000","SELECT DepTimeBlk, SUM(DivDistance) FROM mytable GROUP BY DepTimeBlk LIMIT 10000"],"pql":"SELECT SUM(TaxiOut), SUM(DivDistance) FROM mytable GROUP BY DepTimeBlk TOP 25"}
+{"hsqls":["SELECT DepartureDelayGroups, DestStateName, SUM(WheelsOff) FROM mytable GROUP BY DepartureDelayGroups, DestStateName LIMIT 10000"],"pql":"SELECT SUM(WheelsOff) FROM mytable GROUP BY DepartureDelayGroups, DestStateName TOP 21"}
+{"hsqls":["SELECT Dest, SUM(ArrDel15) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, AVG(CAST(TaxiOut AS DOUBLE)) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, COUNT(AirTime) FROM mytable GROUP BY Dest LIMIT 10000"],"pql":"SELECT SUM(ArrDel15), AVG(TaxiOut), COUNT(AirTime) FROM mytable GROUP BY Dest TOP 21"}
+{"hsqls":["SELECT DestStateFips, ArrDelay, SUM(DaysSinceEpoch) FROM mytable GROUP BY DestStateFips, ArrDelay LIMIT 10000"],"pql":"SELECT SUM(DaysSinceEpoch) FROM mytable GROUP BY DestStateFips, ArrDelay TOP 24"}
+{"hsqls":["SELECT DestWac, DayofMonth, SUM(DestAirportSeqID) FROM mytable GROUP BY DestWac, DayofMonth LIMIT 10000","SELECT DestWac, DayofMonth, MIN(DivDistance) FROM mytable GROUP BY DestWac, DayofMonth LIMIT 10000"],"pql":"SELECT SUM(DestAirportSeqID), MIN(DivDistance) FROM mytable GROUP BY DestWac, DayofMonth TOP 8"}
+{"hsqls":["SELECT DistanceGroup, TotalAddGTime, CRSDepTime, SUM(NASDelay) FROM mytable GROUP BY DistanceGroup, TotalAddGTime, CRSDepTime LIMIT 10000","SELECT DistanceGroup, TotalAddGTime, CRSDepTime, COUNT(DestAirportID) FROM mytable GROUP BY DistanceGroup, TotalAddGTime, CRSDepTime LIMIT 10000","SELECT DistanceGroup, TotalAddGTime, CRSDepTime, SUM(ArrDelay) FROM mytable GROUP BY DistanceGroup, TotalAddGTime, CRSDepTime LIMIT 10000"],"pql":"SELECT SUM(NASDelay), COUNT(DestAirportID), SUM [...]
+{"hsqls":["SELECT DivActualElapsedTime, SUM(WheelsOff) FROM mytable GROUP BY DivActualElapsedTime LIMIT 10000"],"pql":"SELECT SUM(WheelsOff) FROM mytable GROUP BY DivActualElapsedTime TOP 22"}
+{"hsqls":["SELECT DivArrDelay, SUM(DayofMonth) FROM mytable GROUP BY DivArrDelay LIMIT 10000"],"pql":"SELECT SUM(DayofMonth) FROM mytable GROUP BY DivArrDelay TOP 12"}
+{"hsqls":["SELECT DivDistance, AirlineID, DayOfWeek, SUM(DayOfWeek) FROM mytable GROUP BY DivDistance, AirlineID, DayOfWeek LIMIT 10000","SELECT DivDistance, AirlineID, DayOfWeek, MAX(OriginStateFips) FROM mytable GROUP BY DivDistance, AirlineID, DayOfWeek LIMIT 10000","SELECT DivDistance, AirlineID, DayOfWeek, MAX(ActualElapsedTime) FROM mytable GROUP BY DivDistance, AirlineID, DayOfWeek LIMIT 10000"],"pql":"SELECT SUM(DayOfWeek), MAX(OriginStateFips), MAX(ActualElapsedTime) FROM mytabl [...]
+{"hsqls":["SELECT DivReachedDest, SUM(DivAirportLandings) FROM mytable GROUP BY DivReachedDest LIMIT 10000","SELECT DivReachedDest, MAX(DayofMonth) FROM mytable GROUP BY DivReachedDest LIMIT 10000","SELECT DivReachedDest, MAX(OriginStateFips) FROM mytable GROUP BY DivReachedDest LIMIT 10000"],"pql":"SELECT SUM(DivAirportLandings), MAX(DayofMonth), MAX(OriginStateFips) FROM mytable GROUP BY DivReachedDest TOP 10"}
+{"hsqls":["SELECT Diverted, Distance, SUM(ArrDelay) FROM mytable GROUP BY Diverted, Distance LIMIT 10000"],"pql":"SELECT SUM(ArrDelay) FROM mytable GROUP BY Diverted, Distance TOP 21"}
+{"hsqls":["SELECT FirstDepTime, DivAirportLandings, DivArrDelay, SUM(DepartureDelayGroups) FROM mytable GROUP BY FirstDepTime, DivAirportLandings, DivArrDelay LIMIT 10000"],"pql":"SELECT SUM(DepartureDelayGroups) FROM mytable GROUP BY FirstDepTime, DivAirportLandings, DivArrDelay TOP 16"}
+{"hsqls":["SELECT FlightNum, CancellationCode, SUM(DayOfWeek) FROM mytable GROUP BY FlightNum, CancellationCode LIMIT 10000"],"pql":"SELECT SUM(DayOfWeek) FROM mytable GROUP BY FlightNum, CancellationCode TOP 22"}
+{"hsqls":["SELECT Flights, SUM(Month) FROM mytable GROUP BY Flights LIMIT 10000","SELECT Flights, MIN(DistanceGroup) FROM mytable GROUP BY Flights LIMIT 10000","SELECT Flights, MIN(Cancelled) FROM mytable GROUP BY Flights LIMIT 10000"],"pql":"SELECT SUM(Month), MIN(DistanceGroup), MIN(Cancelled) FROM mytable GROUP BY Flights TOP 17"}
+{"hsqls":["SELECT LateAircraftDelay, SecurityDelay, DestAirportID, SUM(CarrierDelay) FROM mytable GROUP BY LateAircraftDelay, SecurityDelay, DestAirportID LIMIT 10000","SELECT LateAircraftDelay, SecurityDelay, DestAirportID, AVG(CAST(NASDelay AS DOUBLE)) FROM mytable GROUP BY LateAircraftDelay, SecurityDelay, DestAirportID LIMIT 10000","SELECT LateAircraftDelay, SecurityDelay, DestAirportID, SUM(DepDelayMinutes) FROM mytable GROUP BY LateAircraftDelay, SecurityDelay, DestAirportID LIMIT [...]
+{"hsqls":["SELECT LongestAddGTime, DestCityMarketID, OriginAirportID, SUM(LongestAddGTime) FROM mytable GROUP BY LongestAddGTime, DestCityMarketID, OriginAirportID LIMIT 10000","SELECT LongestAddGTime, DestCityMarketID, OriginAirportID, COUNT(AirTime) FROM mytable GROUP BY LongestAddGTime, DestCityMarketID, OriginAirportID LIMIT 10000","SELECT LongestAddGTime, DestCityMarketID, OriginAirportID, MAX(Distance) FROM mytable GROUP BY LongestAddGTime, DestCityMarketID, OriginAirportID LIMIT 1 [...]
+{"hsqls":["SELECT Month, SUM(DepDelayMinutes) FROM mytable GROUP BY Month LIMIT 10000","SELECT Month, SUM(ActualElapsedTime) FROM mytable GROUP BY Month LIMIT 10000"],"pql":"SELECT SUM(DepDelayMinutes), SUM(ActualElapsedTime) FROM mytable GROUP BY Month TOP 11"}
+{"hsqls":["SELECT NASDelay, SUM(CRSElapsedTime) FROM mytable GROUP BY NASDelay LIMIT 10000","SELECT NASDelay, AVG(CAST(DepDelayMinutes AS DOUBLE)) FROM mytable GROUP BY NASDelay LIMIT 10000"],"pql":"SELECT SUM(CRSElapsedTime), AVG(DepDelayMinutes) FROM mytable GROUP BY NASDelay"}
+{"hsqls":["SELECT OriginAirportSeqID, FirstDepTime, CarrierDelay, SUM(OriginAirportSeqID) FROM mytable GROUP BY OriginAirportSeqID, FirstDepTime, CarrierDelay LIMIT 10000","SELECT OriginAirportSeqID, FirstDepTime, CarrierDelay, AVG(CAST(Flights AS DOUBLE)) FROM mytable GROUP BY OriginAirportSeqID, FirstDepTime, CarrierDelay LIMIT 10000","SELECT OriginAirportSeqID, FirstDepTime, CarrierDelay, COUNT(WeatherDelay) FROM mytable GROUP BY OriginAirportSeqID, FirstDepTime, CarrierDelay LIMIT 10 [...]
+{"hsqls":["SELECT OriginCityMarketID, SUM(AirTime) FROM mytable GROUP BY OriginCityMarketID LIMIT 10000","SELECT OriginCityMarketID, MAX(DestCityMarketID) FROM mytable GROUP BY OriginCityMarketID LIMIT 10000","SELECT OriginCityMarketID, MIN(AirlineID) FROM mytable GROUP BY OriginCityMarketID LIMIT 10000"],"pql":"SELECT SUM(AirTime), MAX(DestCityMarketID), MIN(AirlineID) FROM mytable GROUP BY OriginCityMarketID TOP 16"}
+{"hsqls":["SELECT OriginCityName, CancellationCode, SUM(LateAircraftDelay) FROM mytable GROUP BY OriginCityName, CancellationCode LIMIT 10000","SELECT OriginCityName, CancellationCode, SUM(TaxiOut) FROM mytable GROUP BY OriginCityName, CancellationCode LIMIT 10000","SELECT OriginCityName, CancellationCode, SUM(CRSElapsedTime) FROM mytable GROUP BY OriginCityName, CancellationCode LIMIT 10000"],"pql":"SELECT SUM(LateAircraftDelay), SUM(TaxiOut), SUM(CRSElapsedTime) FROM mytable GROUP BY O [...]
+{"hsqls":["SELECT OriginState, DestWac, SUM(TotalAddGTime) FROM mytable GROUP BY OriginState, DestWac LIMIT 10000","SELECT OriginState, DestWac, COUNT(NASDelay) FROM mytable GROUP BY OriginState, DestWac LIMIT 10000","SELECT OriginState, DestWac, SUM(WheelsOff) FROM mytable GROUP BY OriginState, DestWac LIMIT 10000"],"pql":"SELECT SUM(TotalAddGTime), COUNT(NASDelay), SUM(WheelsOff) FROM mytable GROUP BY OriginState, DestWac TOP 12"}
+{"hsqls":["SELECT OriginStateFips, LateAircraftDelay, NASDelay, SUM(DivArrDelay) FROM mytable GROUP BY OriginStateFips, LateAircraftDelay, NASDelay LIMIT 10000","SELECT OriginStateFips, LateAircraftDelay, NASDelay, MIN(CRSElapsedTime) FROM mytable GROUP BY OriginStateFips, LateAircraftDelay, NASDelay LIMIT 10000"],"pql":"SELECT SUM(DivArrDelay), MIN(CRSElapsedTime) FROM mytable GROUP BY OriginStateFips, LateAircraftDelay, NASDelay TOP 29"}
+{"hsqls":["SELECT OriginWac, SUM(DivAirportLandings) FROM mytable GROUP BY OriginWac LIMIT 10000","SELECT OriginWac, MAX(TaxiIn) FROM mytable GROUP BY OriginWac LIMIT 10000","SELECT OriginWac, MAX(OriginAirportID) FROM mytable GROUP BY OriginWac LIMIT 10000"],"pql":"SELECT SUM(DivAirportLandings), MAX(TaxiIn), MAX(OriginAirportID) FROM mytable GROUP BY OriginWac TOP 21"}
+{"hsqls":["SELECT Quarter, CRSDepTime, SUM(DivAirportLandings) FROM mytable GROUP BY Quarter, CRSDepTime LIMIT 10000","SELECT Quarter, CRSDepTime, COUNT(TaxiOut) FROM mytable GROUP BY Quarter, CRSDepTime LIMIT 10000","SELECT Quarter, CRSDepTime, AVG(CAST(Cancelled AS DOUBLE)) FROM mytable GROUP BY Quarter, CRSDepTime LIMIT 10000"],"pql":"SELECT SUM(DivAirportLandings), COUNT(TaxiOut), AVG(Cancelled) FROM mytable GROUP BY Quarter, CRSDepTime TOP 20"}
+{"hsqls":["SELECT Quarter, DayOfWeek, SUM(TaxiIn) FROM mytable GROUP BY Quarter, DayOfWeek LIMIT 10000","SELECT Quarter, DayOfWeek, MAX(ActualElapsedTime) FROM mytable GROUP BY Quarter, DayOfWeek LIMIT 10000","SELECT Quarter, DayOfWeek, SUM(DivDistance) FROM mytable GROUP BY Quarter, DayOfWeek LIMIT 10000"],"pql":"SELECT SUM(TaxiIn), MAX(ActualElapsedTime), SUM(DivDistance) FROM mytable GROUP BY Quarter, DayOfWeek TOP 6"}
+{"hsqls":["SELECT TailNum, SUM(ArrDelayMinutes) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, MIN(DepartureDelayGroups) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, COUNT(LongestAddGTime) FROM mytable GROUP BY TailNum LIMIT 10000"],"pql":"SELECT SUM(ArrDelayMinutes), MIN(DepartureDelayGroups), COUNT(LongestAddGTime) FROM mytable GROUP BY TailNum TOP 1"}
+{"hsqls":["SELECT TaxiOut, UniqueCarrier, SUM(WheelsOn) FROM mytable GROUP BY TaxiOut, UniqueCarrier LIMIT 10000","SELECT TaxiOut, UniqueCarrier, AVG(CAST(DestWac AS DOUBLE)) FROM mytable GROUP BY TaxiOut, UniqueCarrier LIMIT 10000"],"pql":"SELECT SUM(WheelsOn), AVG(DestWac) FROM mytable GROUP BY TaxiOut, UniqueCarrier TOP 20"}
+{"hsqls":["SELECT TotalAddGTime, SUM(ArrivalDelayGroups) FROM mytable GROUP BY TotalAddGTime LIMIT 10000","SELECT TotalAddGTime, MAX(Month) FROM mytable GROUP BY TotalAddGTime LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups), MAX(Month) FROM mytable GROUP BY TotalAddGTime TOP 24"}
+{"hsqls":["SELECT WeatherDelay, CancellationCode, DivArrDelay, SUM(ArrDel15) FROM mytable GROUP BY WeatherDelay, CancellationCode, DivArrDelay LIMIT 10000","SELECT WeatherDelay, CancellationCode, DivArrDelay, MIN(DepDelay) FROM mytable GROUP BY WeatherDelay, CancellationCode, DivArrDelay LIMIT 10000"],"pql":"SELECT SUM(ArrDel15), MIN(DepDelay) FROM mytable GROUP BY WeatherDelay, CancellationCode, DivArrDelay TOP 23"}
+{"hsqls":["SELECT WheelsOff, SUM(ActualElapsedTime) FROM mytable GROUP BY WheelsOff LIMIT 10000","SELECT WheelsOff, AVG(CAST(DepDelayMinutes AS DOUBLE)) FROM mytable GROUP BY WheelsOff LIMIT 10000"],"pql":"SELECT SUM(ActualElapsedTime), AVG(DepDelayMinutes) FROM mytable GROUP BY WheelsOff TOP 29"}
+{"hsqls":["SELECT WheelsOn, DayOfWeek, SUM(FirstDepTime) FROM mytable GROUP BY WheelsOn, DayOfWeek LIMIT 10000","SELECT WheelsOn, DayOfWeek, COUNT(DayOfWeek) FROM mytable GROUP BY WheelsOn, DayOfWeek LIMIT 10000","SELECT WheelsOn, DayOfWeek, MAX(DayOfWeek) FROM mytable GROUP BY WheelsOn, DayOfWeek LIMIT 10000"],"pql":"SELECT SUM(FirstDepTime), COUNT(DayOfWeek), MAX(DayOfWeek) FROM mytable GROUP BY WheelsOn, DayOfWeek TOP 1"}
+{"hsqls":["SELECT Year, SecurityDelay, DivAirportLandings, SUM(DestCityMarketID) FROM mytable GROUP BY Year, SecurityDelay, DivAirportLandings LIMIT 10000"],"pql":"SELECT SUM(DestCityMarketID) FROM mytable GROUP BY Year, SecurityDelay, DivAirportLandings TOP 22"}
+
+
+# Filtering on Aggregation
+{"hsqls":["SELECT WeatherDelay, COUNT(*) FROM mytable WHERE TailNum NOT IN ('N937WN', 'N905WN', 'N477WN') OR DestStateFips BETWEEN 12 AND 31 AND ArrTime BETWEEN 1258 AND 806 GROUP BY WeatherDelay LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable WHERE TailNum NOT IN ('N937WN', 'N905WN', 'N477WN') OR DestStateFips BETWEEN 12 AND 31 AND ArrTime BETWEEN 1258 AND 806 GROUP BY WeatherDelay TOP 16"}
+{"hsqls":["SELECT SUM(TotalAddGTime) FROM mytable WHERE AirTime > 202 AND DestStateName BETWEEN 'Louisiana' AND 'Alaska' LIMIT 10000"],"pql":"SELECT SUM(TotalAddGTime) FROM mytable WHERE AirTime > 202 AND DestStateName BETWEEN 'Louisiana' AND 'Alaska' TOP 7"}
+{"hsqls":["SELECT AVG(CAST(AirTime AS DOUBLE)) 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 DivTailNums__MV4 BETWEEN 'N8315C' AND 'N130DL') OR (DivAirports__MV0 IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports__MV1 IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports__MV2 IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') [...]
+{"hsqls":["SELECT AVG(CAST(ArrivalDelayGroups AS DOUBLE)) FROM mytable WHERE DayofMonth >= 5 OR AirTime <= 368 OR Flights BETWEEN 1 AND 1 LIMIT 10000","SELECT SUM(DistanceGroup) FROM mytable WHERE DayofMonth >= 5 OR AirTime <= 368 OR Flights BETWEEN 1 AND 1 LIMIT 10000","SELECT MAX(DayofMonth) FROM mytable WHERE DayofMonth >= 5 OR AirTime <= 368 OR Flights BETWEEN 1 AND 1 LIMIT 10000"],"pql":"SELECT AVG(ArrivalDelayGroups), SUM(DistanceGroup), MAX(DayofMonth) FROM mytable WHERE DayofMont [...]
+{"hsqls":["SELECT AVG(CAST(CRSDepTime AS DOUBLE)) FROM mytable WHERE CancellationCode IN ('C') AND DestWac = 86 LIMIT 10000","SELECT MIN(DepartureDelayGroups) FROM mytable WHERE CancellationCode IN ('C') AND DestWac = 86 LIMIT 10000","SELECT SUM(ArrTime) FROM mytable WHERE CancellationCode IN ('C') AND DestWac = 86 LIMIT 10000"],"pql":"SELECT AVG(CRSDepTime), MIN(DepartureDelayGroups), SUM(ArrTime) FROM mytable WHERE CancellationCode IN ('C') AND DestWac = 86 TOP 16"}
+{"hsqls":["SELECT AVG(CAST(LongestAddGTime AS DOUBLE)) FROM mytable WHERE DivReachedDest <= 0 LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable WHERE DivReachedDest <= 0 LIMIT 10000"],"pql":"SELECT AVG(LongestAddGTime), SUM(DestStateFips) FROM mytable WHERE DivReachedDest <= 0 TOP 22"}
+{"hsqls":["SELECT AVG(CAST(NASDelay AS DOUBLE)) FROM mytable WHERE CRSArrTime = 1850 OR DestStateName <= 'Maryland' LIMIT 10000","SELECT SUM(FirstDepTime) FROM mytable WHERE CRSArrTime = 1850 OR DestStateName <= 'Maryland' LIMIT 10000"],"pql":"SELECT AVG(NASDelay), SUM(FirstDepTime) FROM mytable WHERE CRSArrTime = 1850 OR DestStateName <= 'Maryland' TOP 6"}
+{"hsqls":["SELECT AVG(CAST(OriginAirportSeqID AS DOUBLE)) 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 AND 1315802) LIMIT 10000","SELECT MIN(CarrierDelay) FROM mytable WHERE (DivAirportSeqIDs__MV0 BETWEEN 1039705 AND 1315802 OR DivAirportSeqIDs__MV1 BETWEEN 1039705 A [...]
+{"hsqls":["SELECT AVG(CAST(Year AS DOUBLE)) 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 (1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV4 IN (1702, 2226, 749, 2328, 844)) OR ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 10000","SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE (DivWheelsOffs__MV0 IN (1702, 2226, 749, 23 [...]
+{"hsqls":["SELECT COUNT(ArrivalDelayGroups) FROM mytable WHERE LongestAddGTime = 42 AND ArrTime BETWEEN 2013 AND 1604 OR DivArrDelay BETWEEN 156 AND 348 LIMIT 10000","SELECT SUM(Distance) FROM mytable WHERE LongestAddGTime = 42 AND ArrTime BETWEEN 2013 AND 1604 OR DivArrDelay BETWEEN 156 AND 348 LIMIT 10000"],"pql":"SELECT COUNT(ArrivalDelayGroups), SUM(Distance) FROM mytable WHERE LongestAddGTime = 42 AND ArrTime BETWEEN 2013 AND 1604 OR DivArrDelay BETWEEN 156 AND 348 TOP 4"}
+{"hsqls":["SELECT COUNT(CRSDepTime) FROM mytable WHERE OriginAirportID NOT IN (14794, 12094, 13290, 10754) LIMIT 10000","SELECT SUM(Year) FROM mytable WHERE OriginAirportID NOT IN (14794, 12094, 13290, 10754) LIMIT 10000"],"pql":"SELECT COUNT(CRSDepTime), SUM(Year) FROM mytable WHERE OriginAirportID NOT IN (14794, 12094, 13290, 10754) TOP 20"}
+{"hsqls":["SELECT COUNT(Carrier) FROM mytable WHERE Month > 1 AND OriginStateFips BETWEEN 45 AND 48 LIMIT 10000","SELECT SUM(Cancelled) FROM mytable WHERE Month > 1 AND OriginStateFips BETWEEN 45 AND 48 LIMIT 10000","SELECT MIN(DestStateFips) FROM mytable WHERE Month > 1 AND OriginStateFips BETWEEN 45 AND 48 LIMIT 10000"],"pql":"SELECT COUNT(Carrier), SUM(Cancelled), MIN(DestStateFips) FROM mytable WHERE Month > 1 AND OriginStateFips BETWEEN 45 AND 48 TOP 12"}
+{"hsqls":["SELECT COUNT(DepDelay) FROM mytable WHERE DestCityMarketID NOT IN (30620) LIMIT 10000","SELECT SUM(DepDelayMinutes) FROM mytable WHERE DestCityMarketID NOT IN (30620) LIMIT 10000","SELECT MAX(OriginAirportID) FROM mytable WHERE DestCityMarketID NOT IN (30620) LIMIT 10000"],"pql":"SELECT COUNT(DepDelay), SUM(DepDelayMinutes), MAX(OriginAirportID) FROM mytable WHERE DestCityMarketID NOT IN (30620) TOP 9"}
+{"hsqls":["SELECT COUNT(DepartureDelayGroups) FROM mytable WHERE DayofMonth BETWEEN 12 AND 26 OR DistanceGroup IN (7, 11) LIMIT 10000","SELECT SUM(ArrTime) FROM mytable WHERE DayofMonth BETWEEN 12 AND 26 OR DistanceGroup IN (7, 11) LIMIT 10000","SELECT AVG(CAST(DepDelayMinutes AS DOUBLE)) FROM mytable WHERE DayofMonth BETWEEN 12 AND 26 OR DistanceGroup IN (7, 11) LIMIT 10000"],"pql":"SELECT COUNT(DepartureDelayGroups), SUM(ArrTime), AVG(DepDelayMinutes) FROM mytable WHERE DayofMonth BETW [...]
+{"hsqls":["SELECT COUNT(DestAirportID) FROM mytable WHERE FlightDate NOT IN ('2014-01-14', '2014-01-21', '2014-01-22', '2014-01-20', '2014-01-08') OR WheelsOn NOT IN (2155, 1912) LIMIT 10000","SELECT SUM(CRSArrTime) FROM mytable WHERE FlightDate NOT IN ('2014-01-14', '2014-01-21', '2014-01-22', '2014-01-20', '2014-01-08') OR WheelsOn NOT IN (2155, 1912) LIMIT 10000"],"pql":"SELECT COUNT(DestAirportID), SUM(CRSArrTime) FROM mytable WHERE FlightDate NOT IN ('2014-01-14', '2014-01-21', '201 [...]
+{"hsqls":["SELECT COUNT(DivDistance) FROM mytable WHERE LongestAddGTime IN (20, 74, 28) OR DepTime BETWEEN 1347 AND 944 OR Origin NOT IN ('GRR', 'TUS', 'ALO', 'MDW') LIMIT 10000","SELECT SUM(Diverted) FROM mytable WHERE LongestAddGTime IN (20, 74, 28) OR DepTime BETWEEN 1347 AND 944 OR Origin NOT IN ('GRR', 'TUS', 'ALO', 'MDW') LIMIT 10000"],"pql":"SELECT COUNT(DivDistance), SUM(Diverted) FROM mytable WHERE LongestAddGTime IN (20, 74, 28) OR DepTime BETWEEN 1347 AND 944 OR Origin NOT IN [...]
+{"hsqls":["SELECT COUNT(DivReachedDest) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR TaxiOut BETWEEN 102 AND 18 AND DestStateFips BETWEEN 10 AND 13 LIMIT 10000","SELECT SUM(DivActualElapsedTime) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR TaxiOut BETWEEN 102 AND 18 AND DestStateFips BETWEEN 10 AND 13 LIMIT 10000"],"pql":"SELECT COUNT(DivReachedDest), SUM(DivActualElapsedTime) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR TaxiOut BETWEEN 102 AND 18 AND DestStateFips BETWEEN 10 AND 13 TOP 20"}
+{"hsqls":["SELECT COUNT(Flights) FROM mytable WHERE DestCityMarketID < 31423 LIMIT 10000","SELECT SUM(OriginAirportID) FROM mytable WHERE DestCityMarketID < 31423 LIMIT 10000"],"pql":"SELECT COUNT(Flights), SUM(OriginAirportID) FROM mytable WHERE DestCityMarketID < 31423 TOP 5"}
+{"hsqls":["SELECT COUNT(LongestAddGTime) FROM mytable WHERE Month BETWEEN 1 AND 1 OR CRSArrTime NOT IN (1723) LIMIT 10000","SELECT SUM(OriginCityMarketID) FROM mytable WHERE Month BETWEEN 1 AND 1 OR CRSArrTime NOT IN (1723) LIMIT 10000"],"pql":"SELECT COUNT(LongestAddGTime), SUM(OriginCityMarketID) FROM mytable WHERE Month BETWEEN 1 AND 1 OR CRSArrTime NOT IN (1723) TOP 18"}
+{"hsqls":["SELECT COUNT(Month) 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, 158, 73, 142) OR DestAirportID NOT IN (10423, 13303, 10581, 10747) LIMIT 10000","SELECT SUM(OriginAirportSeqID) FROM mytable WHERE (DivTailNums__MV0 <= 'N530MQ' OR DivTailNums__MV1 <= 'N530MQ' OR DivTailNums__MV2 <= 'N530MQ' OR DivTailNums__MV3 <= 'N530MQ' O [...]
+{"hsqls":["SELECT COUNT(NASDelay) FROM mytable WHERE ArrDel15 IN (1, 0, -9999) OR OriginAirportID >= 12177 LIMIT 10000","SELECT SUM(DepDelayMinutes) FROM mytable WHERE ArrDel15 IN (1, 0, -9999) OR OriginAirportID >= 12177 LIMIT 10000"],"pql":"SELECT COUNT(NASDelay), SUM(DepDelayMinutes) FROM mytable WHERE ArrDel15 IN (1, 0, -9999) OR OriginAirportID >= 12177 TOP 6"}
+{"hsqls":["SELECT COUNT(OriginCityMarketID) FROM mytable WHERE AirTime IN (67, 254, 76) AND SecurityDelay <= 1 LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable WHERE AirTime IN (67, 254, 76) AND SecurityDelay <= 1 LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID), SUM(DestStateFips) FROM mytable WHERE AirTime IN (67, 254, 76) AND SecurityDelay <= 1 TOP 25"}
+{"hsqls":["SELECT COUNT(OriginCityName) FROM mytable WHERE ActualElapsedTime NOT IN (113, 271) LIMIT 10000","SELECT SUM(DistanceGroup) FROM mytable WHERE ActualElapsedTime NOT IN (113, 271) LIMIT 10000"],"pql":"SELECT COUNT(OriginCityName), SUM(DistanceGroup) FROM mytable WHERE ActualElapsedTime NOT IN (113, 271) TOP 3"}
+{"hsqls":["SELECT COUNT(SecurityDelay) FROM mytable WHERE Diverted < 1 AND DistanceGroup NOT IN (7, 5, 11) LIMIT 10000","SELECT SUM(TaxiOut) FROM mytable WHERE Diverted < 1 AND DistanceGroup NOT IN (7, 5, 11) LIMIT 10000","SELECT AVG(CAST(DestWac AS DOUBLE)) FROM mytable WHERE Diverted < 1 AND DistanceGroup NOT IN (7, 5, 11) LIMIT 10000"],"pql":"SELECT COUNT(SecurityDelay), SUM(TaxiOut), AVG(DestWac) FROM mytable WHERE Diverted < 1 AND DistanceGroup NOT IN (7, 5, 11) TOP 9"}
+{"hsqls":["SELECT COUNT(TaxiIn) FROM mytable WHERE DestAirportSeqID >= 1560702 OR SecurityDelay NOT IN (0, 18) OR WeatherDelay = 103 LIMIT 10000","SELECT MIN(DaysSinceEpoch) FROM mytable WHERE DestAirportSeqID >= 1560702 OR SecurityDelay NOT IN (0, 18) OR WeatherDelay = 103 LIMIT 10000","SELECT SUM(OriginAirportSeqID) FROM mytable WHERE DestAirportSeqID >= 1560702 OR SecurityDelay NOT IN (0, 18) OR WeatherDelay = 103 LIMIT 10000"],"pql":"SELECT COUNT(TaxiIn), MIN(DaysSinceEpoch), SUM(Ori [...]
+{"hsqls":["SELECT MAX(AirlineID) FROM mytable WHERE Year = 2014 AND DestStateFips IN (15) LIMIT 10000","SELECT MIN(OriginAirportSeqID) FROM mytable WHERE Year = 2014 AND DestStateFips IN (15) LIMIT 10000","SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE Year = 2014 AND DestStateFips IN (15) LIMIT 10000"],"pql":"SELECT MAX(AirlineID), MIN(OriginAirportSeqID), SUM(ArrivalDelayGroups) FROM mytable WHERE Year = 2014 AND DestStateFips IN (15) TOP 6"}
+{"hsqls":["SELECT MAX(DepDel15) FROM mytable WHERE DestCityName = 'Laramie, WY' LIMIT 10000","SELECT SUM(Diverted) FROM mytable WHERE DestCityName = 'Laramie, WY' LIMIT 10000"],"pql":"SELECT MAX(DepDel15), SUM(Diverted) FROM mytable WHERE DestCityName = 'Laramie, WY'"}
+{"hsqls":["SELECT MAX(DepTime) FROM mytable WHERE DepTime IN (1005, 1811, 1016, 1354, 2023) AND ArrivalDelayGroups = -1 OR TailNum IN ('N597AA', 'N14125', 'N902FR', 'N280WN') LIMIT 10000","SELECT SUM(Month) FROM mytable WHERE DepTime IN (1005, 1811, 1016, 1354, 2023) AND ArrivalDelayGroups = -1 OR TailNum IN ('N597AA', 'N14125', 'N902FR', 'N280WN') LIMIT 10000","SELECT MIN(WheelsOff) FROM mytable WHERE DepTime IN (1005, 1811, 1016, 1354, 2023) AND ArrivalDelayGroups = -1 OR TailNum IN (' [...]
+{"hsqls":["SELECT MAX(DestAirportSeqID) FROM mytable WHERE CRSElapsedTime >= 102 OR LongestAddGTime IN (19, 54) AND FlightDate IN ('2014-01-05', '2014-01-06', '2014-01-03', '2014-01-20', '2014-01-24') LIMIT 10000","SELECT COUNT(DaysSinceEpoch) FROM mytable WHERE CRSElapsedTime >= 102 OR LongestAddGTime IN (19, 54) AND FlightDate IN ('2014-01-05', '2014-01-06', '2014-01-03', '2014-01-20', '2014-01-24') LIMIT 10000","SELECT SUM(FlightNum) FROM mytable WHERE CRSElapsedTime >= 102 OR Longest [...]
+{"hsqls":["SELECT MAX(DestAirportSeqID) FROM mytable WHERE FlightNum NOT IN (5065, 2539, 3182, 3605) LIMIT 10000","SELECT MIN(DivReachedDest) FROM mytable WHERE FlightNum NOT IN (5065, 2539, 3182, 3605) LIMIT 10000","SELECT SUM(Quarter) FROM mytable WHERE FlightNum NOT IN (5065, 2539, 3182, 3605) LIMIT 10000"],"pql":"SELECT MAX(DestAirportSeqID), MIN(DivReachedDest), SUM(Quarter) FROM mytable WHERE FlightNum NOT IN (5065, 2539, 3182, 3605) TOP 26"}
+{"hsqls":["SELECT MAX(DivDistance) FROM mytable WHERE Diverted BETWEEN 0 AND 0 LIMIT 10000","SELECT SUM(CarrierDelay) FROM mytable WHERE Diverted BETWEEN 0 AND 0 LIMIT 10000"],"pql":"SELECT MAX(DivDistance), SUM(CarrierDelay) FROM mytable WHERE Diverted BETWEEN 0 AND 0 TOP 7"}
+{"hsqls":["SELECT MAX(FirstDepTime) FROM mytable WHERE DepTimeBlk BETWEEN '1900-1959' AND '1600-1659' OR TailNum NOT IN ('N584NW') LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable WHERE DepTimeBlk BETWEEN '1900-1959' AND '1600-1659' OR TailNum NOT IN ('N584NW') LIMIT 10000"],"pql":"SELECT MAX(FirstDepTime), SUM(DestStateFips) FROM mytable WHERE DepTimeBlk BETWEEN '1900-1959' AND '1600-1659' OR TailNum NOT IN ('N584NW') TOP 15"}
+{"hsqls":["SELECT MAX(Flights) FROM mytable WHERE WeatherDelay BETWEEN 43 AND 55 LIMIT 10000","SELECT SUM(WeatherDelay) FROM mytable WHERE WeatherDelay BETWEEN 43 AND 55 LIMIT 10000","SELECT AVG(CAST(Diverted AS DOUBLE)) FROM mytable WHERE WeatherDelay BETWEEN 43 AND 55 LIMIT 10000"],"pql":"SELECT MAX(Flights), SUM(WeatherDelay), AVG(Diverted) FROM mytable WHERE WeatherDelay BETWEEN 43 AND 55 TOP 4"}
+{"hsqls":["SELECT MAX(NASDelay) FROM mytable WHERE CRSArrTime < 2352 OR ArrDel15 BETWEEN -9999 AND -9999 OR OriginAirportID BETWEEN 10785 AND 10930 LIMIT 10000","SELECT SUM(Flights) FROM mytable WHERE CRSArrTime < 2352 OR ArrDel15 BETWEEN -9999 AND -9999 OR OriginAirportID BETWEEN 10785 AND 10930 LIMIT 10000","SELECT MAX(Cancelled) FROM mytable WHERE CRSArrTime < 2352 OR ArrDel15 BETWEEN -9999 AND -9999 OR OriginAirportID BETWEEN 10785 AND 10930 LIMIT 10000"],"pql":"SELECT MAX(NASDelay), [...]
+{"hsqls":["SELECT MAX(OriginAirportSeqID) FROM mytable WHERE DestAirportID = 14828 LIMIT 10000","SELECT SUM(DepDel15) FROM mytable WHERE DestAirportID = 14828 LIMIT 10000","SELECT MIN(DepartureDelayGroups) FROM mytable WHERE DestAirportID = 14828 LIMIT 10000"],"pql":"SELECT MAX(OriginAirportSeqID), SUM(DepDel15), MIN(DepartureDelayGroups) FROM mytable WHERE DestAirportID = 14828 TOP 6"}
+{"hsqls":["SELECT MAX(Quarter) FROM mytable WHERE ArrDelayMinutes > 321.0 OR ArrDel15 = 1 LIMIT 10000","SELECT SUM(OriginAirportID) FROM mytable WHERE ArrDelayMinutes > 321.0 OR ArrDel15 = 1 LIMIT 10000","SELECT SUM(DestAirportID) FROM mytable WHERE ArrDelayMinutes > 321.0 OR ArrDel15 = 1 LIMIT 10000"],"pql":"SELECT MAX(Quarter), SUM(OriginAirportID), SUM(DestAirportID) FROM mytable WHERE ArrDelayMinutes > 321.0 OR ArrDel15 = 1 TOP 14"}
+{"hsqls":["SELECT MAX(SecurityDelay) FROM mytable WHERE Origin NOT IN ('BQN', 'HIB') AND ArrDelayMinutes NOT IN (15.0, 218.0) AND DivReachedDest BETWEEN -9999 AND 0 LIMIT 10000","SELECT SUM(DivReachedDest) FROM mytable WHERE Origin NOT IN ('BQN', 'HIB') AND ArrDelayMinutes NOT IN (15.0, 218.0) AND DivReachedDest BETWEEN -9999 AND 0 LIMIT 10000","SELECT MAX(DivReachedDest) FROM mytable WHERE Origin NOT IN ('BQN', 'HIB') AND ArrDelayMinutes NOT IN (15.0, 218.0) AND DivReachedDest BETWEEN - [...]
+{"hsqls":["SELECT MAX(TotalAddGTime) 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 AND 11953) OR SecurityDelay BETWEEN 18 AND -9999 AND ArrTime > 1548 LIMIT 10000","SELECT SUM(DayofMonth) FROM mytable WHERE (DivAirportIDs__MV0 BETWEEN 10721 AND 11953 OR DivAirportIDs__MV1 BETWEEN 10721 AND 11953 OR D [...]
+{"hsqls":["SELECT MIN(ArrDelayMinutes) FROM mytable WHERE DistanceGroup = 3 AND CancellationCode IN ('A', 'B', 'C') OR Distance IN (4983, 723, 1120, 214, 1635) LIMIT 10000","SELECT COUNT(ActualElapsedTime) FROM mytable WHERE DistanceGroup = 3 AND CancellationCode IN ('A', 'B', 'C') OR Distance IN (4983, 723, 1120, 214, 1635) LIMIT 10000","SELECT SUM(FlightNum) FROM mytable WHERE DistanceGroup = 3 AND CancellationCode IN ('A', 'B', 'C') OR Distance IN (4983, 723, 1120, 214, 1635) LIMIT 10 [...]
+{"hsqls":["SELECT MIN(ArrTime) FROM mytable WHERE FirstDepTime NOT IN (2009, 1957, 550) AND DayofMonth <> 2 AND OriginState NOT IN ('IA', 'NY', 'RI', 'MD') LIMIT 10000","SELECT SUM(OriginStateFips) FROM mytable WHERE FirstDepTime NOT IN (2009, 1957, 550) AND DayofMonth <> 2 AND OriginState NOT IN ('IA', 'NY', 'RI', 'MD') LIMIT 10000"],"pql":"SELECT MIN(ArrTime), SUM(OriginStateFips) FROM mytable WHERE FirstDepTime NOT IN (2009, 1957, 550) AND DayofMonth <> 2 AND OriginState NOT IN ('IA', [...]
+{"hsqls":["SELECT MIN(DivDistance) FROM mytable WHERE DivActualElapsedTime >= 265 LIMIT 10000","SELECT SUM(DestWac) FROM mytable WHERE DivActualElapsedTime >= 265 LIMIT 10000","SELECT MIN(CRSElapsedTime) FROM mytable WHERE DivActualElapsedTime >= 265 LIMIT 10000"],"pql":"SELECT MIN(DivDistance), SUM(DestWac), MIN(CRSElapsedTime) FROM mytable WHERE DivActualElapsedTime >= 265 TOP 2"}
+{"hsqls":["SELECT MIN(FlightNum) FROM mytable WHERE FlightNum BETWEEN 2345 AND 4441 AND FlightNum = 3747 LIMIT 10000","SELECT AVG(CAST(DestAirportID AS DOUBLE)) FROM mytable WHERE FlightNum BETWEEN 2345 AND 4441 AND FlightNum = 3747 LIMIT 10000","SELECT SUM(FlightNum) FROM mytable WHERE FlightNum BETWEEN 2345 AND 4441 AND FlightNum = 3747 LIMIT 10000"],"pql":"SELECT MIN(FlightNum), AVG(DestAirportID), SUM(FlightNum) FROM mytable WHERE FlightNum BETWEEN 2345 AND 4441 AND FlightNum = 3747 [...]
+{"hsqls":["SELECT MIN(Flights) 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","SELECT SUM(CRSArrTime) FROM mytable WHERE FlightNum NOT IN (4484) AND (DivAirportSeqIDs__MV0 >= 1323202 OR DivAirportSeqIDs__MV1 >= 1323202 OR DivAirportSeqIDs__MV2 >= 1323202 OR DivAirportSeqI [...]
+{"hsqls":["SELECT MIN(OriginStateFips) FROM mytable WHERE (DivAirports__MV0 > 'PSG' OR DivAirports__MV1 > 'PSG' OR DivAirports__MV2 > 'PSG' OR DivAirports__MV3 > 'PSG' OR DivAirports__MV4 > 'PSG') LIMIT 10000","SELECT 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"],"pql":"SELECT MIN(OriginStateFips), SUM(FirstDepTime) FROM mytable WHERE DivAirports [...]
+{"hsqls":["SELECT MIN(OriginStateFips) 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 10000","SELECT AVG(CAST(OriginAirportSeqID AS DOUBLE)) FROM mytable WHERE (DivWheelsOns__MV0 IN (2041, 2350, 1553, 1546) OR DivWheelsOns__MV1 IN (2041, 2350, 1553, 1546) OR DivWheelsOn [...]
+{"hsqls":["SELECT MIN(Quarter) FROM mytable WHERE ArrTimeBlk > '0600-0659' LIMIT 10000","SELECT SUM(FlightNum) FROM mytable WHERE ArrTimeBlk > '0600-0659' LIMIT 10000"],"pql":"SELECT MIN(Quarter), SUM(FlightNum) FROM mytable WHERE ArrTimeBlk > '0600-0659' TOP 11"}
+{"hsqls":["SELECT MIN(SecurityDelay) FROM mytable WHERE FlightDate < '2014-01-11' OR FlightDate BETWEEN '2014-01-31' AND '2014-01-04' LIMIT 10000","SELECT SUM(FirstDepTime) FROM mytable WHERE FlightDate < '2014-01-11' OR FlightDate BETWEEN '2014-01-31' AND '2014-01-04' LIMIT 10000","SELECT MIN(WheelsOff) FROM mytable WHERE FlightDate < '2014-01-11' OR FlightDate BETWEEN '2014-01-31' AND '2014-01-04' LIMIT 10000"],"pql":"SELECT MIN(SecurityDelay), SUM(FirstDepTime), MIN(WheelsOff) FROM my [...]
+{"hsqls":["SELECT MIN(WheelsOn) 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","SELECT 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 DivTotal [...]
+{"hsqls":["SELECT SUM(ActualElapsedTime) FROM mytable WHERE DepDelay < 177.0 AND TailNum BETWEEN 'N176PQ' AND 'N181PQ' AND LateAircraftDelay BETWEEN 96 AND 123 LIMIT 10000"],"pql":"SELECT SUM(ActualElapsedTime) FROM mytable WHERE DepDelay < 177.0 AND TailNum BETWEEN 'N176PQ' AND 'N181PQ' AND LateAircraftDelay BETWEEN 96 AND 123 TOP 24"}
+{"hsqls":["SELECT SUM(AirTime) FROM mytable WHERE DestAirportID BETWEEN 15389 AND 10731 AND DestState NOT IN ('WI', 'WV') OR DestStateFips < 56 LIMIT 10000","SELECT SUM(DepartureDelayGroups) FROM mytable WHERE DestAirportID BETWEEN 15389 AND 10731 AND DestState NOT IN ('WI', 'WV') OR DestStateFips < 56 LIMIT 10000"],"pql":"SELECT SUM(AirTime), SUM(DepartureDelayGroups) FROM mytable WHERE DestAirportID BETWEEN 15389 AND 10731 AND DestState NOT IN ('WI', 'WV') OR DestStateFips < 56 TOP 24"}
+{"hsqls":["SELECT SUM(AirlineID) FROM mytable WHERE ArrDelay NOT IN (185.0, 193.0, 190.0) LIMIT 10000","SELECT COUNT(DestState) FROM mytable WHERE ArrDelay NOT IN (185.0, 193.0, 190.0) LIMIT 10000"],"pql":"SELECT SUM(AirlineID), COUNT(DestState) FROM mytable WHERE ArrDelay NOT IN (185.0, 193.0, 190.0) TOP 18"}
+{"hsqls":["SELECT SUM(AirlineID) FROM mytable WHERE DayOfWeek BETWEEN 5 AND 7 OR LateAircraftDelay NOT IN (102, 118) OR DistanceGroup BETWEEN 10 AND 6 LIMIT 10000"],"pql":"SELECT SUM(AirlineID) FROM mytable WHERE DayOfWeek BETWEEN 5 AND 7 OR LateAircraftDelay NOT IN (102, 118) OR DistanceGroup BETWEEN 10 AND 6 TOP 1"}
+{"hsqls":["SELECT SUM(ArrDel15) FROM mytable WHERE DivAirportLandings <= 1 AND OriginWac <> 1 LIMIT 10000","SELECT COUNT(ActualElapsedTime) FROM mytable WHERE DivAirportLandings <= 1 AND OriginWac <> 1 LIMIT 10000","SELECT AVG(CAST(ArrDelay AS DOUBLE)) FROM mytable WHERE DivAirportLandings <= 1 AND OriginWac <> 1 LIMIT 10000"],"pql":"SELECT SUM(ArrDel15), COUNT(ActualElapsedTime), AVG(ArrDelay) FROM mytable WHERE DivAirportLandings <= 1 AND OriginWac <> 1 TOP 24"}
+{"hsqls":["SELECT SUM(ArrDelay) FROM mytable WHERE DayOfWeek IN (5, 4) LIMIT 10000","SELECT MIN(Month) FROM mytable WHERE DayOfWeek IN (5, 4) LIMIT 10000"],"pql":"SELECT SUM(ArrDelay), MIN(Month) FROM mytable WHERE DayOfWeek IN (5, 4) TOP 27"}
+{"hsqls":["SELECT SUM(ArrDelayMinutes) FROM mytable WHERE OriginCityMarketID IN (32467, 31721) OR TaxiIn NOT IN (116, 96, 44) AND OriginAirportSeqID BETWEEN 1295302 AND 1288403 LIMIT 10000","SELECT SUM(WheelsOn) FROM mytable WHERE OriginCityMarketID IN (32467, 31721) OR TaxiIn NOT IN (116, 96, 44) AND OriginAirportSeqID BETWEEN 1295302 AND 1288403 LIMIT 10000","SELECT COUNT(ArrTimeBlk) FROM mytable WHERE OriginCityMarketID IN (32467, 31721) OR TaxiIn NOT IN (116, 96, 44) AND OriginAirpor [...]
+{"hsqls":["SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE AirlineID IN (21171) OR TotalAddGTime NOT IN (128, 31, 34, 37) LIMIT 10000","SELECT SUM(DayOfWeek) FROM mytable WHERE AirlineID IN (21171) OR TotalAddGTime NOT IN (128, 31, 34, 37) LIMIT 10000","SELECT SUM(DepDelay) FROM mytable WHERE AirlineID IN (21171) OR TotalAddGTime NOT IN (128, 31, 34, 37) LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups), SUM(DayOfWeek), SUM(DepDelay) FROM mytable WHERE AirlineID IN (21171) OR TotalAd [...]
+{"hsqls":["SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE DestStateFips >= 37 OR AirlineID BETWEEN 19930 AND 20304 LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE DestStateFips >= 37 OR AirlineID BETWEEN 19930 AND 20304 TOP 5"}
+{"hsqls":["SELECT SUM(CRSArrTime) FROM mytable WHERE (DivAirportSeqIDs__MV0 >= 1099402 OR DivAirportSeqIDs__MV1 >= 1099402 OR DivAirportSeqIDs__MV2 >= 1099402 OR DivAirportSeqIDs__MV3 >= 1099402 OR DivAirportSeqIDs__MV4 >= 1099402) OR AirTime IN (152, 239, 240, 264) LIMIT 10000","SELECT SUM(OriginAirportSeqID) FROM mytable WHERE (DivAirportSeqIDs__MV0 >= 1099402 OR DivAirportSeqIDs__MV1 >= 1099402 OR DivAirportSeqIDs__MV2 >= 1099402 OR DivAirportSeqIDs__MV3 >= 1099402 OR DivAirportSeqIDs [...]
+{"hsqls":["SELECT SUM(DaysSinceEpoch) 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 DivDistance <= 328 LIMIT 10000","SELECT AVG(CAST(DepartureDelayGroups AS DOUBLE)) FROM mytable WHERE (DivAirports__MV0 BETWEEN 'MSP' AND 'SAT' OR DivAirports__MV1 BETWEEN 'MSP' AND 'SAT' OR DivA [...]
+{"hsqls":["SELECT SUM(Diverted) FROM mytable WHERE DestState BETWEEN 'AZ' AND 'GA' OR TailNum IN ('N341NB') OR Dest <> 'RNO' LIMIT 10000","SELECT MAX(DivReachedDest) FROM mytable WHERE DestState BETWEEN 'AZ' AND 'GA' OR TailNum IN ('N341NB') OR Dest <> 'RNO' LIMIT 10000"],"pql":"SELECT SUM(Diverted), MAX(DivReachedDest) FROM mytable WHERE DestState BETWEEN 'AZ' AND 'GA' OR TailNum IN ('N341NB') OR Dest <> 'RNO' TOP 21"}
+{"hsqls":["SELECT SUM(FirstDepTime) FROM mytable WHERE TailNum IN ('N77296') OR WheelsOn BETWEEN 2101 AND 1814 LIMIT 10000","SELECT COUNT(OriginAirportID) FROM mytable WHERE TailNum IN ('N77296') OR WheelsOn BETWEEN 2101 AND 1814 LIMIT 10000"],"pql":"SELECT SUM(FirstDepTime), COUNT(OriginAirportID) FROM mytable WHERE TailNum IN ('N77296') OR WheelsOn BETWEEN 2101 AND 1814 TOP 21"}
+{"hsqls":["SELECT SUM(Flights) FROM mytable WHERE (DivAirportIDs__MV0 > 10257 OR DivAirportIDs__MV1 > 10257 OR DivAirportIDs__MV2 > 10257 OR DivAirportIDs__MV3 > 10257 OR DivAirportIDs__MV4 > 10257) OR DepDel15 BETWEEN 1 AND -9999 OR ArrDel15 BETWEEN -9999 AND 0 LIMIT 10000","SELECT AVG(CAST(WheelsOn AS DOUBLE)) FROM mytable WHERE (DivAirportIDs__MV0 > 10257 OR DivAirportIDs__MV1 > 10257 OR DivAirportIDs__MV2 > 10257 OR DivAirportIDs__MV3 > 10257 OR DivAirportIDs__MV4 > 10257) OR DepDel1 [...]
+{"hsqls":["SELECT SUM(LongestAddGTime) FROM mytable WHERE CancellationCode NOT IN ('A', 'B', 'C', 'noodles') OR CancellationCode NOT IN ('A', 'noodles') LIMIT 10000","SELECT AVG(CAST(ArrDelayMinutes AS DOUBLE)) FROM mytable WHERE CancellationCode NOT IN ('A', 'B', 'C', 'noodles') OR CancellationCode NOT IN ('A', 'noodles') LIMIT 10000","SELECT MAX(TaxiOut) FROM mytable WHERE CancellationCode NOT IN ('A', 'B', 'C', 'noodles') OR CancellationCode NOT IN ('A', 'noodles') LIMIT 10000"],"pql" [...]
+{"hsqls":["SELECT SUM(Month) FROM mytable WHERE FirstDepTime <> 1742 AND DestStateName BETWEEN 'Maine' AND 'South Dakota' OR Carrier <= 'UA' LIMIT 10000"],"pql":"SELECT SUM(Month) FROM mytable WHERE FirstDepTime <> 1742 AND DestStateName BETWEEN 'Maine' AND 'South Dakota' OR Carrier <= 'UA' TOP 23"}
+{"hsqls":["SELECT SUM(NASDelay) FROM mytable WHERE CRSDepTime NOT IN (723, 1141) OR DepartureDelayGroups NOT IN (10, 7, 9, 11, 12) LIMIT 10000","SELECT SUM(ArrDelay) FROM mytable WHERE CRSDepTime NOT IN (723, 1141) OR DepartureDelayGroups NOT IN (10, 7, 9, 11, 12) LIMIT 10000"],"pql":"SELECT SUM(NASDelay), SUM(ArrDelay) FROM mytable WHERE CRSDepTime NOT IN (723, 1141) OR DepartureDelayGroups NOT IN (10, 7, 9, 11, 12) TOP 13"}
+{"hsqls":["SELECT SUM(OriginAirportID) FROM mytable WHERE FirstDepTime BETWEEN 612 AND 624 OR ArrDelayMinutes BETWEEN 321.0 AND 996.0 AND Flights IN (1) LIMIT 10000","SELECT COUNT(AirTime) FROM mytable WHERE FirstDepTime BETWEEN 612 AND 624 OR ArrDelayMinutes BETWEEN 321.0 AND 996.0 AND Flights IN (1) LIMIT 10000","SELECT MIN(FirstDepTime) FROM mytable WHERE FirstDepTime BETWEEN 612 AND 624 OR ArrDelayMinutes BETWEEN 321.0 AND 996.0 AND Flights IN (1) LIMIT 10000"],"pql":"SELECT SUM(Orig [...]
+{"hsqls":["SELECT SUM(OriginStateFips) FROM mytable WHERE ArrTime > 858 LIMIT 10000"],"pql":"SELECT SUM(OriginStateFips) FROM mytable WHERE ArrTime > 858 TOP 27"}
+{"hsqls":["SELECT SUM(OriginWac) FROM mytable WHERE ArrTime > 903 AND DivAirportLandings IN (2, 1, 0, 9) OR ArrDelayMinutes NOT IN (7.0) LIMIT 10000","SELECT MIN(Quarter) FROM mytable WHERE ArrTime > 903 AND DivAirportLandings IN (2, 1, 0, 9) OR ArrDelayMinutes NOT IN (7.0) LIMIT 10000","SELECT AVG(CAST(Quarter AS DOUBLE)) FROM mytable WHERE ArrTime > 903 AND DivAirportLandings IN (2, 1, 0, 9) OR ArrDelayMinutes NOT IN (7.0) LIMIT 10000"],"pql":"SELECT SUM(OriginWac), MIN(Quarter), AVG(Q [...]
+{"hsqls":["SELECT SUM(Quarter) FROM mytable WHERE DaysSinceEpoch BETWEEN 16094 AND 16093 OR OriginStateFips >= 41 LIMIT 10000"],"pql":"SELECT SUM(Quarter) FROM mytable WHERE DaysSinceEpoch BETWEEN 16094 AND 16093 OR OriginStateFips >= 41 TOP 8"}
+{"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"],"pql":"SELECT SUM(SecurityDelay) FROM mytable WHERE DivTailNums < 'N712SW' OR Distance BETWEEN 426 AND 994 AND TaxiIn BETWEEN 65 AND 9 TOP 17"}
+{"hsqls":["SELECT SUM(TaxiOut) FROM mytable WHERE DestWac BETWEEN 2 AND 85 LIMIT 10000","SELECT SUM(ActualElapsedTime) FROM mytable WHERE DestWac BETWEEN 2 AND 85 LIMIT 10000","SELECT SUM(DepDelay) FROM mytable WHERE DestWac BETWEEN 2 AND 85 LIMIT 10000"],"pql":"SELECT SUM(TaxiOut), SUM(ActualElapsedTime), SUM(DepDelay) FROM mytable WHERE DestWac BETWEEN 2 AND 85 TOP 25"}
+{"hsqls":["SELECT SUM(TotalAddGTime) FROM mytable WHERE AirlineID <> 20304 AND Year BETWEEN 2014 AND 2014 AND Quarter IN (1) LIMIT 10000"],"pql":"SELECT SUM(TotalAddGTime) FROM mytable WHERE AirlineID <> 20304 AND Year BETWEEN 2014 AND 2014 AND Quarter IN (1) TOP 16"}
+{"hsqls":["SELECT SUM(WeatherDelay) FROM mytable WHERE DaysSinceEpoch NOT IN (16073, 16090, 16079) AND DivAirportLandings BETWEEN 2 AND 1 OR ArrTimeBlk IN ('2000-2059', '0700-0759', '1100-1159', '1300-1359') LIMIT 10000","SELECT SUM(DepTime) FROM mytable WHERE DaysSinceEpoch NOT IN (16073, 16090, 16079) AND DivAirportLandings BETWEEN 2 AND 1 OR ArrTimeBlk IN ('2000-2059', '0700-0759', '1100-1159', '1300-1359') LIMIT 10000","SELECT MIN(TaxiOut) FROM mytable WHERE DaysSinceEpoch NOT IN (16 [...]
+{"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, 16271)) OR FlightNum BETWEEN 4294 AND 5280 LIMIT 10000"],"pql":"SELECT SUM(WheelsOff) FROM mytable WHERE DivAirportIDs IN (11292, 11986, 12819, [...]
+{"hsqls":["SELECT SUM(WheelsOn) FROM mytable WHERE TailNum IN ('N313US', 'N544AA', 'N619AS') LIMIT 10000","SELECT MIN(DistanceGroup) FROM mytable WHERE TailNum IN ('N313US', 'N544AA', 'N619AS') LIMIT 10000","SELECT MAX(CRSArrTime) FROM mytable WHERE TailNum IN ('N313US', 'N544AA', 'N619AS') LIMIT 10000"],"pql":"SELECT SUM(WheelsOn), MIN(DistanceGroup), MAX(CRSArrTime) FROM mytable WHERE TailNum IN ('N313US', 'N544AA', 'N619AS')"}
+{"hsqls":["SELECT SUM(Year) FROM mytable WHERE OriginCityMarketID NOT IN (32457, 33795, 33495, 31049) OR DestWac BETWEEN 65 AND 87 OR OriginState NOT IN ('ND', 'CO') LIMIT 10000","SELECT 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 10000"],"pql":"SELECT SUM(Year), COUNT(ArrTime) FROM mytable WHERE OriginCityMarketID NOT IN (32457, 33795, 33495, 31049) OR DestWac BETWEEN 65 AN [...]
+
+# Filtering & Grouping on Aggregation
+{"hsqls":["SELECT OriginStateName, AVG(CAST(DaysSinceEpoch AS DOUBLE)) FROM mytable WHERE DepartureDelayGroups BETWEEN 1 AND -9999 OR (DivAirportIDs__MV0 BETWEEN 15070 AND 14288 OR DivAirportIDs__MV1 BETWEEN 15070 AND 14288 OR DivAirportIDs__MV2 BETWEEN 15070 AND 14288 OR DivAirportIDs__MV3 BETWEEN 15070 AND 14288 OR DivAirportIDs__MV4 BETWEEN 15070 AND 14288) GROUP BY OriginStateName LIMIT 10000"],"pql":"SELECT AVG(DaysSinceEpoch) FROM mytable WHERE DepartureDelayGroups BETWEEN 1 AND -9 [...]
+{"hsqls":["SELECT Distance, SUM(Month) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000","SELECT Distance, AVG(CAST(ArrDelayMinutes AS DOUBLE)) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000","SELECT Distance, SUM(TaxiIn) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000"],"pql":"SELECT SUM(Month), AVG(ArrDelayMinutes), SUM(TaxiIn) FROM mytable WHERE TaxiOut = 74 OR DayOf [...]
+{"hsqls":["SELECT ActualElapsedTime, SUM(DivReachedDest) FROM mytable WHERE DestAirportID BETWEEN 10551 AND 10792 GROUP BY ActualElapsedTime LIMIT 10000","SELECT ActualElapsedTime, MAX(DepDelay) FROM mytable WHERE DestAirportID BETWEEN 10551 AND 10792 GROUP BY ActualElapsedTime LIMIT 10000"],"pql":"SELECT SUM(DivReachedDest), MAX(DepDelay) FROM mytable WHERE DestAirportID BETWEEN 10551 AND 10792 GROUP BY ActualElapsedTime TOP 15"}
+{"hsqls":["SELECT ArrDel15, SUM(DivDistance) FROM mytable WHERE DestState IN ('NC', 'MS', 'MD', 'SC') AND DestState NOT IN ('DE', 'CT', 'CO', 'FL', 'AL') GROUP BY ArrDel15 LIMIT 10000"],"pql":"SELECT SUM(DivDistance) FROM mytable WHERE DestState IN ('NC', 'MS', 'MD', 'SC') AND DestState NOT IN ('DE', 'CT', 'CO', 'FL', 'AL') GROUP BY ArrDel15 TOP 24"}
+{"hsqls":["SELECT ArrDelay, CancellationCode, SUM(LongestAddGTime) FROM mytable WHERE TailNum <= 'N465WN' GROUP BY ArrDelay, CancellationCode LIMIT 10000","SELECT ArrDelay, CancellationCode, COUNT(DestCityMarketID) FROM mytable WHERE TailNum <= 'N465WN' GROUP BY ArrDelay, CancellationCode LIMIT 10000"],"pql":"SELECT SUM(LongestAddGTime), COUNT(DestCityMarketID) FROM mytable WHERE TailNum <= 'N465WN' GROUP BY ArrDelay, CancellationCode TOP 18"}
+{"hsqls":["SELECT ArrDelayMinutes, WheelsOn, ArrivalDelayGroups, SUM(DepDelay) FROM mytable WHERE ArrivalDelayGroups BETWEEN 9 AND 1 OR Distance IN (2724, 73, 2300) GROUP BY ArrDelayMinutes, WheelsOn, ArrivalDelayGroups LIMIT 10000","SELECT ArrDelayMinutes, WheelsOn, ArrivalDelayGroups, MIN(AirlineID) FROM mytable WHERE ArrivalDelayGroups BETWEEN 9 AND 1 OR Distance IN (2724, 73, 2300) GROUP BY ArrDelayMinutes, WheelsOn, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT SUM(DepDelay), MIN(A [...]
+{"hsqls":["SELECT ArrTime, CRSElapsedTime, SUM(DestAirportID) FROM mytable WHERE ArrTimeBlk > '1000-1059' AND (DivLongestGTimes__MV0 IN (107.0) OR DivLongestGTimes__MV1 IN (107.0) OR DivLongestGTimes__MV2 IN (107.0) OR DivLongestGTimes__MV3 IN (107.0) OR DivLongestGTimes__MV4 IN (107.0)) GROUP BY ArrTime, CRSElapsedTime LIMIT 10000"],"pql":"SELECT SUM(DestAirportID) FROM mytable WHERE ArrTimeBlk > '1000-1059' AND DivLongestGTimes IN (107.0) GROUP BY ArrTime, CRSElapsedTime TOP 15"}
+{"hsqls":["SELECT ArrTimeBlk, DivAirportLandings, SUM(WheelsOn) FROM mytable WHERE ArrDelay BETWEEN 92.0 AND -15.0 AND WheelsOff BETWEEN 1513 AND 910 OR TaxiIn >= 16 GROUP BY ArrTimeBlk, DivAirportLandings LIMIT 10000","SELECT ArrTimeBlk, DivAirportLandings, SUM(CRSDepTime) FROM mytable WHERE ArrDelay BETWEEN 92.0 AND -15.0 AND WheelsOff BETWEEN 1513 AND 910 OR TaxiIn >= 16 GROUP BY ArrTimeBlk, DivAirportLandings LIMIT 10000","SELECT ArrTimeBlk, DivAirportLandings, SUM(OriginAirportID) F [...]
+{"hsqls":["SELECT CRSArrTime, SUM(DayofMonth) FROM mytable WHERE DaysSinceEpoch IN (16095, 16079) AND DivAirportLandings BETWEEN 1 AND 2 OR DestCityName <= 'Tucson, AZ' GROUP BY CRSArrTime LIMIT 10000","SELECT CRSArrTime, SUM(ArrTime) FROM mytable WHERE DaysSinceEpoch IN (16095, 16079) AND DivAirportLandings BETWEEN 1 AND 2 OR DestCityName <= 'Tucson, AZ' GROUP BY CRSArrTime LIMIT 10000"],"pql":"SELECT SUM(DayofMonth), SUM(ArrTime) FROM mytable WHERE DaysSinceEpoch IN (16095, 16079) AND [...]
+{"hsqls":["SELECT CRSDepTime, SUM(WeatherDelay) FROM mytable WHERE WheelsOn BETWEEN 1939 AND 2335 OR Quarter NOT IN (1) GROUP BY CRSDepTime LIMIT 10000","SELECT CRSDepTime, MIN(DestAirportSeqID) FROM mytable WHERE WheelsOn BETWEEN 1939 AND 2335 OR Quarter NOT IN (1) GROUP BY CRSDepTime LIMIT 10000","SELECT CRSDepTime, MAX(DayOfWeek) FROM mytable WHERE WheelsOn BETWEEN 1939 AND 2335 OR Quarter NOT IN (1) GROUP BY CRSDepTime LIMIT 10000"],"pql":"SELECT SUM(WeatherDelay), MIN(DestAirportSeq [...]
+{"hsqls":["SELECT CRSElapsedTime, SUM(ArrivalDelayGroups) FROM mytable WHERE (DivWheelsOffs__MV0 IN (1831, 1337, 1816) OR DivWheelsOffs__MV1 IN (1831, 1337, 1816) OR DivWheelsOffs__MV2 IN (1831, 1337, 1816) OR DivWheelsOffs__MV3 IN (1831, 1337, 1816) OR DivWheelsOffs__MV4 IN (1831, 1337, 1816)) OR CarrierDelay = 235 GROUP BY CRSElapsedTime LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE DivWheelsOffs IN (1831, 1337, 1816) OR CarrierDelay = 235 GROUP BY CRSElapsedTi [...]
+{"hsqls":["SELECT CancellationCode, SUM(WheelsOn) FROM mytable WHERE Quarter NOT IN (1) OR Cancelled BETWEEN 1 AND 0 GROUP BY CancellationCode LIMIT 10000","SELECT CancellationCode, MIN(DaysSinceEpoch) FROM mytable WHERE Quarter NOT IN (1) OR Cancelled BETWEEN 1 AND 0 GROUP BY CancellationCode LIMIT 10000","SELECT CancellationCode, MIN(AirlineID) FROM mytable WHERE Quarter NOT IN (1) OR Cancelled BETWEEN 1 AND 0 GROUP BY CancellationCode LIMIT 10000"],"pql":"SELECT SUM(WheelsOn), MIN(Day [...]
+{"hsqls":["SELECT Cancelled, DivActualElapsedTime, SUM(DepDelay) FROM mytable WHERE DaysSinceEpoch > 16086 OR Flights NOT IN (1) GROUP BY Cancelled, DivActualElapsedTime LIMIT 10000"],"pql":"SELECT SUM(DepDelay) FROM mytable WHERE DaysSinceEpoch > 16086 OR Flights NOT IN (1) GROUP BY Cancelled, DivActualElapsedTime TOP 5"}
+{"hsqls":["SELECT CarrierDelay, ArrivalDelayGroups, SUM(AirTime) FROM mytable WHERE DestAirportID >= 15096 AND DestWac BETWEEN 15 AND 74 OR ArrTime BETWEEN 1941 AND 951 GROUP BY CarrierDelay, ArrivalDelayGroups LIMIT 10000","SELECT CarrierDelay, ArrivalDelayGroups, MIN(CRSDepTime) FROM mytable WHERE DestAirportID >= 15096 AND DestWac BETWEEN 15 AND 74 OR ArrTime BETWEEN 1941 AND 951 GROUP BY CarrierDelay, ArrivalDelayGroups LIMIT 10000","SELECT CarrierDelay, ArrivalDelayGroups, MIN(Arriv [...]
+{"hsqls":["SELECT DayofMonth, SUM(CRSArrTime) FROM mytable WHERE ArrDelay <> 364.0 GROUP BY DayofMonth LIMIT 10000","SELECT DayofMonth, MIN(CRSElapsedTime) FROM mytable WHERE ArrDelay <> 364.0 GROUP BY DayofMonth LIMIT 10000"],"pql":"SELECT SUM(CRSArrTime), MIN(CRSElapsedTime) FROM mytable WHERE ArrDelay <> 364.0 GROUP BY DayofMonth TOP 2"}
+{"hsqls":["SELECT DaysSinceEpoch, DayOfWeek, SUM(FirstDepTime) FROM mytable WHERE Quarter BETWEEN 1 AND 1 AND DestState IN ('UT') GROUP BY DaysSinceEpoch, DayOfWeek LIMIT 10000","SELECT DaysSinceEpoch, DayOfWeek, COUNT(AirTime) FROM mytable WHERE Quarter BETWEEN 1 AND 1 AND DestState IN ('UT') GROUP BY DaysSinceEpoch, DayOfWeek LIMIT 10000","SELECT DaysSinceEpoch, DayOfWeek, MAX(LateAircraftDelay) FROM mytable WHERE Quarter BETWEEN 1 AND 1 AND DestState IN ('UT') GROUP BY DaysSinceEpoch, [...]
+{"hsqls":["SELECT DaysSinceEpoch, SUM(OriginStateFips) FROM mytable WHERE CRSDepTime BETWEEN 2145 AND 2219 AND Month IN (1) GROUP BY DaysSinceEpoch LIMIT 10000"],"pql":"SELECT SUM(OriginStateFips) FROM mytable WHERE CRSDepTime BETWEEN 2145 AND 2219 AND Month IN (1) GROUP BY DaysSinceEpoch TOP 15"}
+{"hsqls":["SELECT DepDel15, SUM(Flights) FROM mytable WHERE ArrivalDelayGroups BETWEEN 12 AND 9 AND Flights IN (1) OR DestCityName = 'Fort Lauderdale, FL' GROUP BY DepDel15 LIMIT 10000","SELECT DepDel15, MIN(DivReachedDest) FROM mytable WHERE ArrivalDelayGroups BETWEEN 12 AND 9 AND Flights IN (1) OR DestCityName = 'Fort Lauderdale, FL' GROUP BY DepDel15 LIMIT 10000"],"pql":"SELECT SUM(Flights), MIN(DivReachedDest) FROM mytable WHERE ArrivalDelayGroups BETWEEN 12 AND 9 AND Flights IN (1) [...]
+{"hsqls":["SELECT DepTimeBlk, SUM(ArrivalDelayGroups) FROM mytable WHERE ArrivalDelayGroups BETWEEN -1 AND 4 GROUP BY DepTimeBlk LIMIT 10000","SELECT DepTimeBlk, COUNT(OriginStateName) FROM mytable WHERE ArrivalDelayGroups BETWEEN -1 AND 4 GROUP BY DepTimeBlk LIMIT 10000","SELECT DepTimeBlk, AVG(CAST(DayofMonth AS DOUBLE)) FROM mytable WHERE ArrivalDelayGroups BETWEEN -1 AND 4 GROUP BY DepTimeBlk LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups), COUNT(OriginStateName), AVG(DayofMonth) [...]
+{"hsqls":["SELECT DepartureDelayGroups, SUM(DepDelayMinutes) FROM mytable WHERE DestStateName IN ('North Carolina') GROUP BY DepartureDelayGroups LIMIT 10000","SELECT DepartureDelayGroups, MIN(DestAirportSeqID) FROM mytable WHERE DestStateName IN ('North Carolina') GROUP BY DepartureDelayGroups LIMIT 10000"],"pql":"SELECT SUM(DepDelayMinutes), MIN(DestAirportSeqID) FROM mytable WHERE DestStateName IN ('North Carolina') GROUP BY DepartureDelayGroups TOP 6"}
+{"hsqls":["SELECT Dest, SUM(CarrierDelay) FROM mytable WHERE DivReachedDest IN (1, -9999) OR (DivWheelsOffs__MV0 BETWEEN 940 AND 1534 OR DivWheelsOffs__MV1 BETWEEN 940 AND 1534 OR DivWheelsOffs__MV2 BETWEEN 940 AND 1534 OR DivWheelsOffs__MV3 BETWEEN 940 AND 1534 OR DivWheelsOffs__MV4 BETWEEN 940 AND 1534) GROUP BY Dest LIMIT 10000","SELECT Dest, MIN(DestAirportSeqID) FROM mytable WHERE DivReachedDest IN (1, -9999) OR (DivWheelsOffs__MV0 BETWEEN 940 AND 1534 OR DivWheelsOffs__MV1 BETWEEN [...]
+{"hsqls":["SELECT DestAirportID, SUM(TaxiIn) FROM mytable WHERE CRSArrTime <= 1646 GROUP BY DestAirportID LIMIT 10000","SELECT DestAirportID, MIN(Month) FROM mytable WHERE CRSArrTime <= 1646 GROUP BY DestAirportID LIMIT 10000"],"pql":"SELECT SUM(TaxiIn), MIN(Month) FROM mytable WHERE CRSArrTime <= 1646 GROUP BY DestAirportID TOP 21"}
+{"hsqls":["SELECT DestAirportSeqID, DepDel15, ArrivalDelayGroups, SUM(WheelsOff) FROM mytable WHERE DivReachedDest IN (1, 0, -9999) GROUP BY DestAirportSeqID, DepDel15, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT SUM(WheelsOff) FROM mytable WHERE DivReachedDest IN (1, 0, -9999) GROUP BY DestAirportSeqID, DepDel15, ArrivalDelayGroups TOP 11"}
+{"hsqls":["SELECT DestStateName, DepDel15, Origin, SUM(ArrDelayMinutes) FROM mytable WHERE DestAirportSeqID > 1312702 AND ArrDelayMinutes BETWEEN 14.0 AND 305.0 GROUP BY DestStateName, DepDel15, Origin LIMIT 10000"],"pql":"SELECT SUM(ArrDelayMinutes) FROM mytable WHERE DestAirportSeqID > 1312702 AND ArrDelayMinutes BETWEEN 14.0 AND 305.0 GROUP BY DestStateName, DepDel15, Origin TOP 11"}
+{"hsqls":["SELECT Distance, SUM(Month) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000","SELECT Distance, AVG(CAST(ArrDelayMinutes AS DOUBLE)) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000","SELECT Distance, SUM(TaxiIn) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000"],"pql":"SELECT SUM(Month), AVG(ArrDelayMinutes), SUM(TaxiIn) FROM mytable WHERE TaxiOut = 74 OR DayOf [...]
+{"hsqls":["SELECT DistanceGroup, CarrierDelay, AirTime, SUM(LateAircraftDelay) FROM mytable WHERE Dest BETWEEN 'MBS' AND 'LCH' OR (DivAirportSeqIDs__MV0 >= 1489302 OR DivAirportSeqIDs__MV1 >= 1489302 OR DivAirportSeqIDs__MV2 >= 1489302 OR DivAirportSeqIDs__MV3 >= 1489302 OR DivAirportSeqIDs__MV4 >= 1489302) GROUP BY DistanceGroup, CarrierDelay, AirTime LIMIT 10000","SELECT DistanceGroup, CarrierDelay, AirTime, AVG(CAST(FirstDepTime AS DOUBLE)) FROM mytable WHERE Dest BETWEEN 'MBS' AND 'L [...]
+{"hsqls":["SELECT Diverted, SUM(NASDelay) FROM mytable WHERE Cancelled NOT IN (1) OR Distance IN (764, 301, 715, 945) GROUP BY Diverted LIMIT 10000","SELECT Diverted, SUM(FirstDepTime) FROM mytable WHERE Cancelled NOT IN (1) OR Distance IN (764, 301, 715, 945) GROUP BY Diverted LIMIT 10000","SELECT Diverted, COUNT(CRSDepTime) FROM mytable WHERE Cancelled NOT IN (1) OR Distance IN (764, 301, 715, 945) GROUP BY Diverted LIMIT 10000"],"pql":"SELECT SUM(NASDelay), SUM(FirstDepTime), COUNT(CR [...]
+{"hsqls":["SELECT FirstDepTime, NASDelay, SUM(WheelsOff) FROM mytable WHERE DivReachedDest >= 1 GROUP BY FirstDepTime, NASDelay LIMIT 10000","SELECT FirstDepTime, NASDelay, AVG(CAST(DistanceGroup AS DOUBLE)) FROM mytable WHERE DivReachedDest >= 1 GROUP BY FirstDepTime, NASDelay LIMIT 10000"],"pql":"SELECT SUM(WheelsOff), AVG(DistanceGroup) FROM mytable WHERE DivReachedDest >= 1 GROUP BY FirstDepTime, NASDelay TOP 16"}
+{"hsqls":["SELECT FlightDate, SUM(OriginAirportID) FROM mytable WHERE DepDel15 IN (1, 0, -9999) OR DivActualElapsedTime <= 338 GROUP BY FlightDate LIMIT 10000","SELECT FlightDate, SUM(CRSArrTime) FROM mytable WHERE DepDel15 IN (1, 0, -9999) OR DivActualElapsedTime <= 338 GROUP BY FlightDate LIMIT 10000"],"pql":"SELECT SUM(OriginAirportID), SUM(CRSArrTime) FROM mytable WHERE DepDel15 IN (1, 0, -9999) OR DivActualElapsedTime <= 338 GROUP BY FlightDate TOP 18"}
+{"hsqls":["SELECT FlightNum, DestStateFips, DestCityName, SUM(ArrDelay) FROM mytable WHERE SecurityDelay BETWEEN 1 AND 14 GROUP BY FlightNum, DestStateFips, DestCityName LIMIT 10000","SELECT FlightNum, DestStateFips, DestCityName, COUNT(CancellationCode) FROM mytable WHERE SecurityDelay BETWEEN 1 AND 14 GROUP BY FlightNum, DestStateFips, DestCityName LIMIT 10000"],"pql":"SELECT SUM(ArrDelay), COUNT(CancellationCode) FROM mytable WHERE SecurityDelay BETWEEN 1 AND 14 GROUP BY FlightNum, De [...]
+{"hsqls":["SELECT Flights, TotalAddGTime, Cancelled, SUM(DestAirportSeqID) FROM mytable WHERE DestStateFips < 32 OR TaxiIn >= 56 GROUP BY Flights, TotalAddGTime, Cancelled LIMIT 10000"],"pql":"SELECT SUM(DestAirportSeqID) FROM mytable WHERE DestStateFips < 32 OR TaxiIn >= 56 GROUP BY Flights, TotalAddGTime, Cancelled TOP 26"}
+{"hsqls":["SELECT LateAircraftDelay, ArrivalDelayGroups, SUM(DestAirportSeqID) FROM mytable WHERE UniqueCarrier NOT IN ('EV', 'DL', 'AA', 'VX') OR (DivLongestGTimes__MV0 > 108.0 OR DivLongestGTimes__MV1 > 108.0 OR DivLongestGTimes__MV2 > 108.0 OR DivLongestGTimes__MV3 > 108.0 OR DivLongestGTimes__MV4 > 108.0) OR NASDelay BETWEEN 13 AND 14 GROUP BY LateAircraftDelay, ArrivalDelayGroups LIMIT 10000","SELECT LateAircraftDelay, ArrivalDelayGroups, MAX(DestCityMarketID) FROM mytable WHERE Uni [...]
+{"hsqls":["SELECT LongestAddGTime, SUM(DepDelayMinutes) FROM mytable WHERE (DivWheelsOns__MV0 IN (1437, 813, 58, 2357, 140) OR DivWheelsOns__MV1 IN (1437, 813, 58, 2357, 140) OR DivWheelsOns__MV2 IN (1437, 813, 58, 2357, 140) OR DivWheelsOns__MV3 IN (1437, 813, 58, 2357, 140) OR DivWheelsOns__MV4 IN (1437, 813, 58, 2357, 140)) GROUP BY LongestAddGTime LIMIT 10000"],"pql":"SELECT SUM(DepDelayMinutes) FROM mytable WHERE DivWheelsOns IN (1437, 813, 58, 2357, 140) GROUP BY LongestAddGTime TOP 19"}
+{"hsqls":["SELECT Month, SUM(Cancelled) FROM mytable WHERE Dest BETWEEN 'ATL' AND 'PSE' AND UniqueCarrier BETWEEN 'US' AND 'US' OR ArrTimeBlk <= '0800-0859' GROUP BY Month LIMIT 10000","SELECT Month, COUNT(DestAirportID) FROM mytable WHERE Dest BETWEEN 'ATL' AND 'PSE' AND UniqueCarrier BETWEEN 'US' AND 'US' OR ArrTimeBlk <= '0800-0859' GROUP BY Month LIMIT 10000","SELECT Month, AVG(CAST(DepartureDelayGroups AS DOUBLE)) FROM mytable WHERE Dest BETWEEN 'ATL' AND 'PSE' AND UniqueCarrier BET [...]
+{"hsqls":["SELECT NASDelay, SUM(TaxiOut) FROM mytable WHERE CancellationCode > 'C' GROUP BY NASDelay LIMIT 10000","SELECT NASDelay, MAX(Distance) FROM mytable WHERE CancellationCode > 'C' GROUP BY NASDelay LIMIT 10000"],"pql":"SELECT SUM(TaxiOut), MAX(Distance) FROM mytable WHERE CancellationCode > 'C' GROUP BY NASDelay TOP 6"}
+{"hsqls":["SELECT Origin, AirlineID, SUM(AirTime) FROM mytable WHERE OriginState BETWEEN 'MS' AND 'PR' GROUP BY Origin, AirlineID LIMIT 10000","SELECT Origin, AirlineID, COUNT(DaysSinceEpoch) FROM mytable WHERE OriginState BETWEEN 'MS' AND 'PR' GROUP BY Origin, AirlineID LIMIT 10000","SELECT Origin, AirlineID, COUNT(WeatherDelay) FROM mytable WHERE OriginState BETWEEN 'MS' AND 'PR' GROUP BY Origin, AirlineID LIMIT 10000"],"pql":"SELECT SUM(AirTime), COUNT(DaysSinceEpoch), COUNT(WeatherDe [...]
+{"hsqls":["SELECT Origin, SUM(CarrierDelay) FROM mytable WHERE DepDelayMinutes BETWEEN 141.0 AND 192.0 AND DestAirportID IN (11042, 11630, 11481, 10693) GROUP BY Origin LIMIT 10000","SELECT Origin, MAX(DestAirportSeqID) FROM mytable WHERE DepDelayMinutes BETWEEN 141.0 AND 192.0 AND DestAirportID IN (11042, 11630, 11481, 10693) GROUP BY Origin LIMIT 10000","SELECT Origin, SUM(CRSDepTime) FROM mytable WHERE DepDelayMinutes BETWEEN 141.0 AND 192.0 AND DestAirportID IN (11042, 11630, 11481, [...]
+{"hsqls":["SELECT OriginAirportID, SUM(CRSArrTime) FROM mytable WHERE DepDelay IN (270.0) OR OriginCityMarketID BETWEEN 32389 AND 32511 OR CRSDepTime BETWEEN 1028 AND 1408 GROUP BY OriginAirportID LIMIT 10000","SELECT OriginAirportID, MAX(CRSDepTime) FROM mytable WHERE DepDelay IN (270.0) OR OriginCityMarketID BETWEEN 32389 AND 32511 OR CRSDepTime BETWEEN 1028 AND 1408 GROUP BY OriginAirportID LIMIT 10000","SELECT OriginAirportID, MAX(Cancelled) FROM mytable WHERE DepDelay IN (270.0) OR [...]
+{"hsqls":["SELECT OriginAirportSeqID, DestAirportSeqID, CancellationCode, SUM(DayOfWeek) FROM mytable WHERE DestStateFips NOT IN (46) OR UniqueCarrier IN ('US') GROUP BY OriginAirportSeqID, DestAirportSeqID, CancellationCode LIMIT 10000","SELECT OriginAirportSeqID, DestAirportSeqID, CancellationCode, AVG(CAST(DistanceGroup AS DOUBLE)) FROM mytable WHERE DestStateFips NOT IN (46) OR UniqueCarrier IN ('US') GROUP BY OriginAirportSeqID, DestAirportSeqID, CancellationCode LIMIT 10000"],"pql" [...]
+{"hsqls":["SELECT OriginCityMarketID, SUM(Year) FROM mytable WHERE (DivTotalGTimes__MV0 IN (6, 36) OR DivTotalGTimes__MV1 IN (6, 36) OR DivTotalGTimes__MV2 IN (6, 36) OR DivTotalGTimes__MV3 IN (6, 36) OR DivTotalGTimes__MV4 IN (6, 36)) GROUP BY OriginCityMarketID LIMIT 10000"],"pql":"SELECT SUM(Year) FROM mytable WHERE DivTotalGTimes IN (6, 36) GROUP BY OriginCityMarketID TOP 2"}
+{"hsqls":["SELECT OriginCityName, ArrTime, DestAirportID, SUM(LateAircraftDelay) FROM mytable WHERE Month < 1 OR SecurityDelay IN (18, 8, 27) GROUP BY OriginCityName, ArrTime, DestAirportID LIMIT 10000","SELECT OriginCityName, ArrTime, DestAirportID, AVG(CAST(SecurityDelay AS DOUBLE)) FROM mytable WHERE Month < 1 OR SecurityDelay IN (18, 8, 27) GROUP BY OriginCityName, ArrTime, DestAirportID LIMIT 10000"],"pql":"SELECT SUM(LateAircraftDelay), AVG(SecurityDelay) FROM mytable WHERE Month < [...]
+{"hsqls":["SELECT OriginState, Dest, SUM(AirTime) FROM mytable WHERE (DivLongestGTimes__MV0 < 6.0 OR DivLongestGTimes__MV1 < 6.0 OR DivLongestGTimes__MV2 < 6.0 OR DivLongestGTimes__MV3 < 6.0 OR DivLongestGTimes__MV4 < 6.0) AND FlightDate NOT IN ('2014-01-14', '2014-01-13', '2014-01-09', '2014-01-23') GROUP BY OriginState, Dest LIMIT 10000","SELECT OriginState, Dest, SUM(DestAirportSeqID) FROM mytable WHERE (DivLongestGTimes__MV0 < 6.0 OR DivLongestGTimes__MV1 < 6.0 OR DivLongestGTimes__M [...]
+{"hsqls":["SELECT OriginStateFips, Flights, SUM(CarrierDelay) FROM mytable WHERE OriginCityName < 'Pittsburgh, PA' OR ArrTimeBlk IN ('1700-1759', '1000-1059', '0800-0859', '0001-0559') OR DepDelayMinutes IN (337.0, 11.0) GROUP BY OriginStateFips, Flights LIMIT 10000","SELECT OriginStateFips, Flights, MAX(DepDelayMinutes) FROM mytable WHERE OriginCityName < 'Pittsburgh, PA' OR ArrTimeBlk IN ('1700-1759', '1000-1059', '0800-0859', '0001-0559') OR DepDelayMinutes IN (337.0, 11.0) GROUP BY O [...]
+{"hsqls":["SELECT OriginStateFips, SUM(ArrDelay) FROM mytable WHERE OriginCityName >= 'Muskegon, MI' OR CRSDepTime BETWEEN 1558 AND 1336 OR SecurityDelay IN (1, 14) GROUP BY OriginStateFips LIMIT 10000"],"pql":"SELECT SUM(ArrDelay) FROM mytable WHERE OriginCityName >= 'Muskegon, MI' OR CRSDepTime BETWEEN 1558 AND 1336 OR SecurityDelay IN (1, 14) GROUP BY OriginStateFips TOP 6"}
+{"hsqls":["SELECT OriginWac, SUM(TaxiOut) FROM mytable WHERE Quarter IN (1) OR (DivAirportSeqIDs__MV0 IN (1125203) OR DivAirportSeqIDs__MV1 IN (1125203) OR DivAirportSeqIDs__MV2 IN (1125203) OR DivAirportSeqIDs__MV3 IN (1125203) OR DivAirportSeqIDs__MV4 IN (1125203)) GROUP BY OriginWac LIMIT 10000","SELECT OriginWac, AVG(CAST(DayofMonth AS DOUBLE)) FROM mytable WHERE Quarter IN (1) OR (DivAirportSeqIDs__MV0 IN (1125203) OR DivAirportSeqIDs__MV1 IN (1125203) OR DivAirportSeqIDs__MV2 IN (1 [...]
+{"hsqls":["SELECT Quarter, ArrDelay, OriginStateName, SUM(DepDelayMinutes) FROM mytable WHERE ArrDel15 = 0 GROUP BY Quarter, ArrDelay, OriginStateName LIMIT 10000","SELECT Quarter, ArrDelay, OriginStateName, AVG(CAST(DepDelay AS DOUBLE)) FROM mytable WHERE ArrDel15 = 0 GROUP BY Quarter, ArrDelay, OriginStateName LIMIT 10000"],"pql":"SELECT SUM(DepDelayMinutes), AVG(DepDelay) FROM mytable WHERE ArrDel15 = 0 GROUP BY Quarter, ArrDelay, OriginStateName TOP 5"}
+{"hsqls":["SELECT SecurityDelay, ActualElapsedTime, WheelsOn, SUM(Distance) FROM mytable WHERE ActualElapsedTime > 251 GROUP BY SecurityDelay, ActualElapsedTime, WheelsOn LIMIT 10000","SELECT SecurityDelay, ActualElapsedTime, WheelsOn, COUNT(WeatherDelay) FROM mytable WHERE ActualElapsedTime > 251 GROUP BY SecurityDelay, ActualElapsedTime, WheelsOn LIMIT 10000"],"pql":"SELECT SUM(Distance), COUNT(WeatherDelay) FROM mytable WHERE ActualElapsedTime > 251 GROUP BY SecurityDelay, ActualElaps [...]
+{"hsqls":["SELECT TailNum, DivAirportLandings, SUM(DestAirportSeqID) FROM mytable WHERE FlightNum IN (4925, 5156, 4484, 656) AND DivActualElapsedTime BETWEEN 305 AND 363 GROUP BY TailNum, DivAirportLandings LIMIT 10000","SELECT TailNum, DivAirportLandings, SUM(DepDelay) FROM mytable WHERE FlightNum IN (4925, 5156, 4484, 656) AND DivActualElapsedTime BETWEEN 305 AND 363 GROUP BY TailNum, DivAirportLandings LIMIT 10000"],"pql":"SELECT SUM(DestAirportSeqID), SUM(DepDelay) FROM mytable WHERE [...]
+{"hsqls":["SELECT TailNum, SUM(DepDelay) FROM mytable WHERE OriginStateName NOT IN ('Texas', 'Rhode Island') AND DivArrDelay NOT IN (145, 175, 167) GROUP BY TailNum LIMIT 10000","SELECT TailNum, AVG(CAST(WheelsOn AS DOUBLE)) FROM mytable WHERE OriginStateName NOT IN ('Texas', 'Rhode Island') AND DivArrDelay NOT IN (145, 175, 167) GROUP BY TailNum LIMIT 10000"],"pql":"SELECT SUM(DepDelay), AVG(WheelsOn) FROM mytable WHERE OriginStateName NOT IN ('Texas', 'Rhode Island') AND DivArrDelay NO [...]
+{"hsqls":["SELECT TaxiIn, UniqueCarrier, DivActualElapsedTime, SUM(DivActualElapsedTime) FROM mytable WHERE LateAircraftDelay IN (164, 91, 39, 101) GROUP BY TaxiIn, UniqueCarrier, DivActualElapsedTime LIMIT 10000"],"pql":"SELECT SUM(DivActualElapsedTime) FROM mytable WHERE LateAircraftDelay IN (164, 91, 39, 101) GROUP BY TaxiIn, UniqueCarrier, DivActualElapsedTime"}
+{"hsqls":["SELECT TaxiOut, ActualElapsedTime, Dest, SUM(ArrDelayMinutes) FROM mytable WHERE (DivTotalGTimes__MV0 = 13 OR DivTotalGTimes__MV1 = 13 OR DivTotalGTimes__MV2 = 13 OR DivTotalGTimes__MV3 = 13 OR DivTotalGTimes__MV4 = 13) AND (DivAirportSeqIDs__MV0 <= 1385103 OR DivAirportSeqIDs__MV1 <= 1385103 OR DivAirportSeqIDs__MV2 <= 1385103 OR DivAirportSeqIDs__MV3 <= 1385103 OR DivAirportSeqIDs__MV4 <= 1385103) AND DestWac <> 14 GROUP BY TaxiOut, ActualElapsedTime, Dest LIMIT 10000","SELE [...]
+{"hsqls":["SELECT TaxiOut, ArrDel15, SUM(AirTime) FROM mytable WHERE TailNum = 'N76528' OR OriginWac BETWEEN 13 AND 22 GROUP BY TaxiOut, ArrDel15 LIMIT 10000"],"pql":"SELECT SUM(AirTime) FROM mytable WHERE TailNum = 'N76528' OR OriginWac BETWEEN 13 AND 22 GROUP BY TaxiOut, ArrDel15 TOP 9"}
+{"hsqls":["SELECT TotalAddGTime, SUM(ArrDelay) FROM mytable WHERE ArrDelayMinutes > 246.0 AND DayOfWeek < 6 AND AirlineID IN (20398, 19805, 21171, 19977) GROUP BY TotalAddGTime LIMIT 10000"],"pql":"SELECT SUM(ArrDelay) FROM mytable WHERE ArrDelayMinutes > 246.0 AND DayOfWeek < 6 AND AirlineID IN (20398, 19805, 21171, 19977) GROUP BY TotalAddGTime TOP 4"}
+{"hsqls":["SELECT UniqueCarrier, SUM(ArrDelayMinutes) FROM mytable WHERE Distance = 220 GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, MAX(ArrDelayMinutes) FROM mytable WHERE Distance = 220 GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, MIN(DayofMonth) FROM mytable WHERE Distance = 220 GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT SUM(ArrDelayMinutes), MAX(ArrDelayMinutes), MIN(DayofMonth) FROM mytable WHERE Distance = 220 GROUP BY UniqueCarrier TOP 6"}
+{"hsqls":["SELECT WeatherDelay, SUM(DestAirportSeqID) FROM mytable WHERE OriginCityMarketID IN (30431, 32177, 32982, 34236, 34027) OR AirlineID IN (20398, 19393) GROUP BY WeatherDelay LIMIT 10000"],"pql":"SELECT SUM(DestAirportSeqID) FROM mytable WHERE OriginCityMarketID IN (30431, 32177, 32982, 34236, 34027) OR AirlineID IN (20398, 19393) GROUP BY WeatherDelay TOP 17"}
+{"hsqls":["SELECT WeatherDelay, SUM(Diverted) FROM mytable WHERE (DivTailNums__MV0 >= 'N462WN' OR DivTailNums__MV1 >= 'N462WN' OR DivTailNums__MV2 >= 'N462WN' OR DivTailNums__MV3 >= 'N462WN' OR DivTailNums__MV4 >= 'N462WN') GROUP BY WeatherDelay LIMIT 10000"],"pql":"SELECT SUM(Diverted) FROM mytable WHERE DivTailNums >= 'N462WN' GROUP BY WeatherDelay TOP 25"}
+{"hsqls":["SELECT WheelsOff, DestAirportSeqID, DayofMonth, SUM(WheelsOn) FROM mytable WHERE Cancelled NOT IN (1, 0) OR SecurityDelay > -9999 AND DestStateName BETWEEN 'Oklahoma' AND 'South Dakota' GROUP BY WheelsOff, DestAirportSeqID, DayofMonth LIMIT 10000","SELECT WheelsOff, DestAirportSeqID, DayofMonth, SUM(DestWac) FROM mytable WHERE Cancelled NOT IN (1, 0) OR SecurityDelay > -9999 AND DestStateName BETWEEN 'Oklahoma' AND 'South Dakota' GROUP BY WheelsOff, DestAirportSeqID, DayofMont [...]
+{"hsqls":["SELECT WheelsOff, TotalAddGTime, SUM(OriginAirportSeqID) FROM mytable WHERE CancellationCode BETWEEN 'C' AND 'B' OR DayofMonth < 21 OR DivArrDelay BETWEEN 231 AND 1651 GROUP BY WheelsOff, TotalAddGTime LIMIT 10000","SELECT WheelsOff, TotalAddGTime, MAX(DestWac) FROM mytable WHERE CancellationCode BETWEEN 'C' AND 'B' OR DayofMonth < 21 OR DivArrDelay BETWEEN 231 AND 1651 GROUP BY WheelsOff, TotalAddGTime LIMIT 10000"],"pql":"SELECT SUM(OriginAirportSeqID), MAX(DestWac) FROM myt [...]
+{"hsqls":["SELECT WheelsOff, Year, DivArrDelay, SUM(AirlineID) FROM mytable WHERE DestAirportID = 14730 AND FlightDate <> '2014-01-08' AND TailNum <> 'N965WN' GROUP BY WheelsOff, Year, DivArrDelay LIMIT 10000"],"pql":"SELECT SUM(AirlineID) FROM mytable WHERE DestAirportID = 14730 AND FlightDate <> '2014-01-08' AND TailNum <> 'N965WN' GROUP BY WheelsOff, Year, DivArrDelay TOP 11"}
+{"hsqls":["SELECT WheelsOn, DayOfWeek, SUM(DepDelay) FROM mytable WHERE DestAirportSeqID IN (1195302, 1349503, 1425202, 1467903) GROUP BY WheelsOn, DayOfWeek LIMIT 10000","SELECT WheelsOn, DayOfWeek, MAX(AirTime) FROM mytable WHERE DestAirportSeqID IN (1195302, 1349503, 1425202, 1467903) GROUP BY WheelsOn, DayOfWeek LIMIT 10000","SELECT WheelsOn, DayOfWeek, MIN(Distance) FROM mytable WHERE DestAirportSeqID IN (1195302, 1349503, 1425202, 1467903) GROUP BY WheelsOn, DayOfWeek LIMIT 10000"] [...]
+{"hsqls":["SELECT WheelsOn, SUM(ArrDelayMinutes) FROM mytable WHERE TailNum IN ('N3EEAA', 'N646JB', 'N453SW', 'N929DL', 'N913SW') OR Origin <> 'CMI' GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, SUM(DaysSinceEpoch) FROM mytable WHERE TailNum IN ('N3EEAA', 'N646JB', 'N453SW', 'N929DL', 'N913SW') OR Origin <> 'CMI' GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, AVG(CAST(Flights AS DOUBLE)) FROM mytable WHERE TailNum IN ('N3EEAA', 'N646JB', 'N453SW', 'N929DL', 'N913SW') OR Origin <> 'C [...]
+{"hsqls":["SELECT WheelsOn, SUM(Year) FROM mytable WHERE (DivAirports__MV0 IN ('TUS', 'DAY', 'TWF') OR DivAirports__MV1 IN ('TUS', 'DAY', 'TWF') OR DivAirports__MV2 IN ('TUS', 'DAY', 'TWF') OR DivAirports__MV3 IN ('TUS', 'DAY', 'TWF') OR DivAirports__MV4 IN ('TUS', 'DAY', 'TWF')) OR CRSDepTime NOT IN (735, 813, 1042, 946) OR DestAirportID NOT IN (12523, 10185, 11612, 12888, 13367) GROUP BY WheelsOn LIMIT 10000"],"pql":"SELECT SUM(Year) FROM mytable WHERE DivAirports IN ('TUS', 'DAY', 'TW [...]
+{"hsqls":["SELECT Year, AirlineID, SUM(DivReachedDest) FROM mytable WHERE DaysSinceEpoch IN (16078, 16091) AND WheelsOff <> 1536 GROUP BY Year, AirlineID LIMIT 10000","SELECT Year, AirlineID, MAX(FlightNum) FROM mytable WHERE DaysSinceEpoch IN (16078, 16091) AND WheelsOff <> 1536 GROUP BY Year, AirlineID LIMIT 10000","SELECT Year, AirlineID, MIN(DayofMonth) FROM mytable WHERE DaysSinceEpoch IN (16078, 16091) AND WheelsOff <> 1536 GROUP BY Year, AirlineID LIMIT 10000"],"pql":"SELECT SUM(D [...]
+{"hsqls":["SELECT Year, ArrDelayMinutes, SUM(CRSDepTime) FROM mytable WHERE DepDelay = 109.0 AND DivArrDelay < 85 GROUP BY Year, ArrDelayMinutes LIMIT 10000","SELECT Year, ArrDelayMinutes, MAX(DepartureDelayGroups) FROM mytable WHERE DepDelay = 109.0 AND DivArrDelay < 85 GROUP BY Year, ArrDelayMinutes LIMIT 10000","SELECT Year, ArrDelayMinutes, MIN(ArrivalDelayGroups) FROM mytable WHERE DepDelay = 109.0 AND DivArrDelay < 85 GROUP BY Year, ArrDelayMinutes LIMIT 10000"],"pql":"SELECT SUM(C [...]
+{"hsqls":["SELECT Year, ArrTime, SUM(DistanceGroup) FROM mytable WHERE DestAirportID NOT IN (11076, 14193) AND DestWac <= 86 AND ArrTime = 1343 GROUP BY Year, ArrTime LIMIT 10000"],"pql":"SELECT SUM(DistanceGroup) FROM mytable WHERE DestAirportID NOT IN (11076, 14193) AND DestWac <= 86 AND ArrTime = 1343 GROUP BY Year, ArrTime TOP 1"}
+{"hsqls":["SELECT Year, LongestAddGTime, SUM(NASDelay) FROM mytable WHERE CRSElapsedTime BETWEEN 257 AND 224 AND DayofMonth NOT IN (20, 18, 13) OR DepTimeBlk >= '1600-1659' GROUP BY Year, LongestAddGTime LIMIT 10000","SELECT Year, LongestAddGTime, MAX(ActualElapsedTime) FROM mytable WHERE CRSElapsedTime BETWEEN 257 AND 224 AND DayofMonth NOT IN (20, 18, 13) OR DepTimeBlk >= '1600-1659' GROUP BY Year, LongestAddGTime LIMIT 10000","SELECT Year, LongestAddGTime, AVG(CAST(DestWac AS DOUBLE)) [...]
+{"hsqls":["SELECT Year, SUM(NASDelay) FROM mytable WHERE Cancelled = 0 AND OriginAirportID IN (11503, 11884, 12891, 12206) AND Cancelled BETWEEN 0 AND 0 GROUP BY Year LIMIT 10000","SELECT Year, AVG(CAST(CRSElapsedTime AS DOUBLE)) FROM mytable WHERE Cancelled = 0 AND OriginAirportID IN (11503, 11884, 12891, 12206) AND Cancelled BETWEEN 0 AND 0 GROUP BY Year LIMIT 10000"],"pql":"SELECT SUM(NASDelay), AVG(CRSElapsedTime) FROM mytable WHERE Cancelled = 0 AND OriginAirportID IN (11503, 11884, [...]
+
+# Selection
+{"hsqls":["SELECT ActualElapsedTime FROM mytable LIMIT 10000"],"pql":"SELECT ActualElapsedTime FROM mytable LIMIT 8"}
+{"hsqls":["SELECT ActualElapsedTime FROM mytable WHERE LongestAddGTime BETWEEN 51 AND 97 AND (DivAirportSeqIDs__MV0 BETWEEN 1324402 AND 1161802 OR DivAirportSeqIDs__MV1 BETWEEN 1324402 AND 1161802 OR DivAirportSeqIDs__MV2 BETWEEN 1324402 AND 1161802 OR DivAirportSeqIDs__MV3 BETWEEN 1324402 AND 1161802 OR DivAirportSeqIDs__MV4 BETWEEN 1324402 AND 1161802) OR WeatherDelay <= -9999 LIMIT 10000"],"pql":"SELECT ActualElapsedTime FROM mytable WHERE LongestAddGTime BETWEEN 51 AND 97 AND DivAirp [...]
+{"hsqls":["SELECT ActualElapsedTime, WheelsOn FROM mytable WHERE DepTimeBlk <= '1900-1959' OR UniqueCarrier BETWEEN 'AA' AND 'B6' LIMIT 10000"],"pql":"SELECT ActualElapsedTime, WheelsOn FROM mytable WHERE DepTimeBlk <= '1900-1959' OR UniqueCarrier BETWEEN 'AA' AND 'B6' LIMIT 21"}
+{"hsqls":["SELECT AirTime FROM mytable WHERE DestStateName BETWEEN 'Louisiana' AND 'U.S. Virgin Islands' AND ArrDelay BETWEEN -9999.0 AND 184.0 LIMIT 10000"],"pql":"SELECT AirTime FROM mytable WHERE DestStateName BETWEEN 'Louisiana' AND 'U.S. Virgin Islands' AND ArrDelay BETWEEN -9999.0 AND 184.0 LIMIT 16"}
+{"hsqls":["SELECT AirTime, AirlineID FROM mytable WHERE DestAirportSeqID > 1457402 AND OriginStateFips = 30 OR Flights BETWEEN 1 AND 1 LIMIT 10000"],"pql":"SELECT AirTime, AirlineID FROM mytable WHERE DestAirportSeqID > 1457402 AND OriginStateFips = 30 OR Flights BETWEEN 1 AND 1 LIMIT 6"}
+{"hsqls":["SELECT AirlineID FROM mytable WHERE (DivAirportSeqIDs__MV0 <= 1013503 OR DivAirportSeqIDs__MV1 <= 1013503 OR DivAirportSeqIDs__MV2 <= 1013503 OR DivAirportSeqIDs__MV3 <= 1013503 OR DivAirportSeqIDs__MV4 <= 1013503) AND OriginCityName >= 'Yakutat, AK' LIMIT 10000"],"pql":"SELECT AirlineID FROM mytable WHERE DivAirportSeqIDs <= 1013503 AND OriginCityName >= 'Yakutat, AK' LIMIT 16"}
+{"hsqls":["SELECT AirlineID FROM mytable WHERE Quarter BETWEEN 1 AND 1 AND DestAirportSeqID BETWEEN 1029904 AND 1219702 OR (DivTotalGTimes__MV0 BETWEEN 63 AND 90 OR DivTotalGTimes__MV1 BETWEEN 63 AND 90 OR DivTotalGTimes__MV2 BETWEEN 63 AND 90 OR DivTotalGTimes__MV3 BETWEEN 63 AND 90 OR DivTotalGTimes__MV4 BETWEEN 63 AND 90) LIMIT 10000"],"pql":"SELECT AirlineID FROM mytable WHERE Quarter BETWEEN 1 AND 1 AND DestAirportSeqID BETWEEN 1029904 AND 1219702 OR DivTotalGTimes BETWEEN 63 AND 90 [...]
+{"hsqls":["SELECT ArrDelayMinutes FROM mytable WHERE OriginState IN ('IN', 'NJ') AND OriginStateName <> 'Texas' AND (DivAirportIDs__MV0 IN (11630, 14828, 14006, 10785) OR DivAirportIDs__MV1 IN (11630, 14828, 14006, 10785) OR DivAirportIDs__MV2 IN (11630, 14828, 14006, 10785) OR DivAirportIDs__MV3 IN (11630, 14828, 14006, 10785) OR DivAirportIDs__MV4 IN (11630, 14828, 14006, 10785)) LIMIT 10000"],"pql":"SELECT ArrDelayMinutes FROM mytable WHERE OriginState IN ('IN', 'NJ') AND OriginStateN [...]
+{"hsqls":["SELECT ArrTime FROM mytable WHERE DaysSinceEpoch <= 16079 LIMIT 10000"],"pql":"SELECT ArrTime FROM mytable WHERE DaysSinceEpoch <= 16079 LIMIT 8"}
+{"hsqls":["SELECT ArrTime FROM mytable WHERE DestState NOT IN ('SD') OR ArrivalDelayGroups >= 6 OR OriginStateName BETWEEN 'West Virginia' AND 'Wisconsin' LIMIT 10000"],"pql":"SELECT ArrTime FROM mytable WHERE DestState NOT IN ('SD') OR ArrivalDelayGroups >= 6 OR OriginStateName BETWEEN 'West Virginia' AND 'Wisconsin' LIMIT 17"}
+{"hsqls":["SELECT CRSDepTime FROM mytable WHERE LongestAddGTime <> 63 AND DepTimeBlk IN ('1000-1059', '0900-0959', '1900-1959', '0001-0559', '1400-1459') LIMIT 10000"],"pql":"SELECT CRSDepTime FROM mytable WHERE LongestAddGTime <> 63 AND DepTimeBlk IN ('1000-1059', '0900-0959', '1900-1959', '0001-0559', '1400-1459') LIMIT 25"}
+{"hsqls":["SELECT CRSElapsedTime FROM mytable WHERE OriginState IN ('NM', 'WY', 'NY') AND ActualElapsedTime BETWEEN 423 AND 365 OR TaxiOut IN (21, 91, 40, 11) LIMIT 10000"],"pql":"SELECT CRSElapsedTime FROM mytable WHERE OriginState IN ('NM', 'WY', 'NY') AND ActualElapsedTime BETWEEN 423 AND 365 OR TaxiOut IN (21, 91, 40, 11) LIMIT 13"}
+{"hsqls":["SELECT CancellationCode, DayOfWeek FROM mytable WHERE Year >= 2014 AND ArrTimeBlk IN ('2200-2259') LIMIT 10000"],"pql":"SELECT CancellationCode, DayOfWeek FROM mytable WHERE Year >= 2014 AND ArrTimeBlk IN ('2200-2259') LIMIT 16"}
+{"hsqls":["SELECT Cancelled FROM mytable WHERE TaxiOut <= 7 AND CancellationCode BETWEEN 'noodles' AND 'noodles' AND OriginAirportID < 11146 LIMIT 10000"],"pql":"SELECT Cancelled FROM mytable WHERE TaxiOut <= 7 AND CancellationCode BETWEEN 'noodles' AND 'noodles' AND OriginAirportID < 11146 LIMIT 8"}
+{"hsqls":["SELECT Carrier, SecurityDelay, DivArrDelay FROM mytable WHERE Dest NOT IN ('OAK') OR DepDelay <> 34.0 AND DayofMonth IN (18) LIMIT 10000"],"pql":"SELECT Carrier, SecurityDelay, DivArrDelay FROM mytable WHERE Dest NOT IN ('OAK') OR DepDelay <> 34.0 AND DayofMonth IN (18) LIMIT 10"}
+{"hsqls":["SELECT CarrierDelay FROM mytable WHERE NASDelay BETWEEN 75 AND 35 AND OriginAirportSeqID > 1299204 OR TaxiIn NOT IN (4, 16, 84) LIMIT 10000"],"pql":"SELECT CarrierDelay FROM mytable WHERE NASDelay BETWEEN 75 AND 35 AND OriginAirportSeqID > 1299204 OR TaxiIn NOT IN (4, 16, 84) LIMIT 9"}
+{"hsqls":["SELECT CarrierDelay, DivAirportLandings, OriginStateName FROM mytable WHERE (DivWheelsOns__MV0 IN (1411, 1648, 2228, 1122, 2339) OR DivWheelsOns__MV1 IN (1411, 1648, 2228, 1122, 2339) OR DivWheelsOns__MV2 IN (1411, 1648, 2228, 1122, 2339) OR DivWheelsOns__MV3 IN (1411, 1648, 2228, 1122, 2339) OR DivWheelsOns__MV4 IN (1411, 1648, 2228, 1122, 2339)) LIMIT 10000"],"pql":"SELECT CarrierDelay, DivAirportLandings, OriginStateName FROM mytable WHERE DivWheelsOns IN (1411, 1648, 2228, [...]
+{"hsqls":["SELECT DaysSinceEpoch FROM mytable WHERE CRSElapsedTime >= 172 AND DayOfWeek BETWEEN 1 AND 6 LIMIT 10000"],"pql":"SELECT DaysSinceEpoch FROM mytable WHERE CRSElapsedTime >= 172 AND DayOfWeek BETWEEN 1 AND 6 LIMIT 8"}
+{"hsqls":["SELECT DepDelay, DaysSinceEpoch FROM mytable WHERE OriginWac IN (2, 92, 91, 54, 38) AND DestAirportSeqID BETWEEN 1198002 AND 1347603 LIMIT 10000"],"pql":"SELECT DepDelay, DaysSinceEpoch FROM mytable WHERE OriginWac IN (2, 92, 91, 54, 38) AND DestAirportSeqID BETWEEN 1198002 AND 1347603 LIMIT 19"}
+{"hsqls":["SELECT DepDelayMinutes, DivWheelsOffs__MV0, DivWheelsOffs__MV1, DivWheelsOffs__MV2, DivWheelsOffs__MV3, DivWheelsOffs__MV4 FROM mytable WHERE (DivTotalGTimes__MV0 IN (94, 30, 112, 32, 62) OR DivTotalGTimes__MV1 IN (94, 30, 112, 32, 62) OR DivTotalGTimes__MV2 IN (94, 30, 112, 32, 62) OR DivTotalGTimes__MV3 IN (94, 30, 112, 32, 62) OR DivTotalGTimes__MV4 IN (94, 30, 112, 32, 62)) OR WheelsOn IN (736, 559, 927, 2155) LIMIT 10000"],"pql":"SELECT DepDelayMinutes, DivWheelsOffs FROM [...]
+{"hsqls":["SELECT DepTimeBlk FROM mytable WHERE SecurityDelay BETWEEN 14 AND 4 OR CRSArrTime NOT IN (1605, 1518) LIMIT 10000"],"pql":"SELECT DepTimeBlk FROM mytable WHERE SecurityDelay BETWEEN 14 AND 4 OR CRSArrTime NOT IN (1605, 1518) LIMIT 5"}
+{"hsqls":["SELECT DepartureDelayGroups, SecurityDelay FROM mytable WHERE CRSDepTime NOT IN (1035, 1305) OR DestAirportID BETWEEN 14869 AND 12884 LIMIT 10000"],"pql":"SELECT DepartureDelayGroups, SecurityDelay FROM mytable WHERE CRSDepTime NOT IN (1035, 1305) OR DestAirportID BETWEEN 14869 AND 12884 LIMIT 18"}
+{"hsqls":["SELECT DestAirportSeqID, ArrivalDelayGroups FROM mytable WHERE OriginCityName IN ('Hibbing, MN', 'Hayden, CO', 'Hartford, CT', 'Dayton, OH') LIMIT 10000"],"pql":"SELECT DestAirportSeqID, ArrivalDelayGroups FROM mytable WHERE OriginCityName IN ('Hibbing, MN', 'Hayden, CO', 'Hartford, CT', 'Dayton, OH') LIMIT 17"}
+{"hsqls":["SELECT DestState, CRSArrTime, TailNum FROM mytable WHERE DivReachedDest NOT IN (1) OR DepTimeBlk <> '0800-0859' AND (DivAirportIDs__MV0 >= 16271 OR DivAirportIDs__MV1 >= 16271 OR DivAirportIDs__MV2 >= 16271 OR DivAirportIDs__MV3 >= 16271 OR DivAirportIDs__MV4 >= 16271) LIMIT 10000"],"pql":"SELECT DestState, CRSArrTime, TailNum FROM mytable WHERE DivReachedDest NOT IN (1) OR DepTimeBlk <> '0800-0859' AND DivAirportIDs >= 16271 LIMIT 27"}
+{"hsqls":["SELECT DivAirportSeqIDs__MV0, DivAirportSeqIDs__MV1, DivAirportSeqIDs__MV2, DivAirportSeqIDs__MV3, DivAirportSeqIDs__MV4, DivArrDelay FROM mytable WHERE Carrier > 'AS' AND DepDelay IN (-14.0, 93.0, 47.0) OR OriginWac BETWEEN 39 AND 45 LIMIT 10000"],"pql":"SELECT DivAirportSeqIDs, DivArrDelay FROM mytable WHERE Carrier > 'AS' AND DepDelay IN (-14.0, 93.0, 47.0) OR OriginWac BETWEEN 39 AND 45 LIMIT 21"}
+{"hsqls":["SELECT DivWheelsOns__MV0, DivWheelsOns__MV1, DivWheelsOns__MV2, DivWheelsOns__MV3, DivWheelsOns__MV4 FROM mytable WHERE OriginCityName IN ('Green Bay, WI') OR Diverted BETWEEN 0 AND 0 OR WheelsOn > 2334 LIMIT 10000"],"pql":"SELECT DivWheelsOns FROM mytable WHERE OriginCityName IN ('Green Bay, WI') OR Diverted BETWEEN 0 AND 0 OR WheelsOn > 2334 LIMIT 16"}
+{"hsqls":["SELECT Flights, ArrTimeBlk FROM mytable WHERE Distance >= 1166 AND DestWac IN (41, 34, 37, 12) OR AirTime BETWEEN 191 AND 40 LIMIT 10000"],"pql":"SELECT Flights, ArrTimeBlk FROM mytable WHERE Distance >= 1166 AND DestWac IN (41, 34, 37, 12) OR AirTime BETWEEN 191 AND 40 LIMIT 6"}
+{"hsqls":["SELECT LateAircraftDelay FROM mytable WHERE (DivAirportIDs__MV0 IN (11905, 10185, 13244, 13433, 10397) OR DivAirportIDs__MV1 IN (11905, 10185, 13244, 13433, 10397) OR DivAirportIDs__MV2 IN (11905, 10185, 13244, 13433, 10397) OR DivAirportIDs__MV3 IN (11905, 10185, 13244, 13433, 10397) OR DivAirportIDs__MV4 IN (11905, 10185, 13244, 13433, 10397)) LIMIT 10000"],"pql":"SELECT LateAircraftDelay FROM mytable WHERE DivAirportIDs IN (11905, 10185, 13244, 13433, 10397) LIMIT 20"}
+{"hsqls":["SELECT LongestAddGTime FROM mytable WHERE DivAirportLandings NOT IN (1, 0) OR AirTime <> 355 LIMIT 10000"],"pql":"SELECT LongestAddGTime FROM mytable WHERE DivAirportLandings NOT IN (1, 0) OR AirTime <> 355 LIMIT 26"}
+{"hsqls":["SELECT Month FROM mytable WHERE DaysSinceEpoch IN (16084, 16095, 16086, 16079) AND DestStateName NOT IN ('Wyoming', 'Texas') LIMIT 10000"],"pql":"SELECT Month FROM mytable WHERE DaysSinceEpoch IN (16084, 16095, 16086, 16079) AND DestStateName NOT IN ('Wyoming', 'Texas') LIMIT 25"}
+{"hsqls":["SELECT NASDelay FROM mytable WHERE OriginAirportID IN (10423, 14905, 14635, 12191) LIMIT 10000"],"pql":"SELECT NASDelay FROM mytable WHERE OriginAirportID IN (10423, 14905, 14635, 12191) LIMIT 19"}
+{"hsqls":["SELECT OriginStateName FROM mytable WHERE (DivAirportIDs__MV0 IN (10980) OR DivAirportIDs__MV1 IN (10980) OR DivAirportIDs__MV2 IN (10980) OR DivAirportIDs__MV3 IN (10980) OR DivAirportIDs__MV4 IN (10980)) LIMIT 10000"],"pql":"SELECT OriginStateName FROM mytable WHERE DivAirportIDs IN (10980) LIMIT 7"}
+{"hsqls":["SELECT OriginStateName FROM mytable WHERE Carrier BETWEEN 'FL' AND 'HA' AND DivActualElapsedTime <= 1968 LIMIT 10000"],"pql":"SELECT OriginStateName FROM mytable WHERE Carrier BETWEEN 'FL' AND 'HA' AND DivActualElapsedTime <= 1968 LIMIT 1"}
+{"hsqls":["SELECT OriginWac, DivArrDelay, DivActualElapsedTime FROM mytable LIMIT 10000"],"pql":"SELECT OriginWac, DivArrDelay, DivActualElapsedTime FROM mytable LIMIT 12"}
+{"hsqls":["SELECT OriginWac, UniqueCarrier FROM mytable WHERE ActualElapsedTime BETWEEN 70 AND 191 OR DivDistance >= 24 AND AirlineID <> 19805 LIMIT 10000"],"pql":"SELECT OriginWac, UniqueCarrier FROM mytable WHERE ActualElapsedTime BETWEEN 70 AND 191 OR DivDistance >= 24 AND AirlineID <> 19805 LIMIT 23"}
+{"hsqls":["SELECT Quarter FROM mytable WHERE DepTime IN (1808, 1735) OR LateAircraftDelay <> 157 AND (DivAirports__MV0 = 'INL' OR DivAirports__MV1 = 'INL' OR DivAirports__MV2 = 'INL' OR DivAirports__MV3 = 'INL' OR DivAirports__MV4 = 'INL') LIMIT 10000"],"pql":"SELECT Quarter FROM mytable WHERE DepTime IN (1808, 1735) OR LateAircraftDelay <> 157 AND DivAirports = 'INL' LIMIT 2"}
+{"hsqls":["SELECT Quarter FROM mytable WHERE OriginAirportID NOT IN (13158, 10732, 10980, 14006, 10781) AND Carrier >= 'MQ' OR Flights BETWEEN 1 AND 1 LIMIT 10000"],"pql":"SELECT Quarter FROM mytable WHERE OriginAirportID NOT IN (13158, 10732, 10980, 14006, 10781) AND Carrier >= 'MQ' OR Flights BETWEEN 1 AND 1 LIMIT 8"}
+{"hsqls":["SELECT SecurityDelay, ActualElapsedTime, NASDelay FROM mytable WHERE OriginAirportSeqID <= 1130802 OR OriginStateFips >= 26 AND CRSArrTime <= 1017 LIMIT 10000"],"pql":"SELECT SecurityDelay, ActualElapsedTime, NASDelay FROM mytable WHERE OriginAirportSeqID <= 1130802 OR OriginStateFips >= 26 AND CRSArrTime <= 1017 LIMIT 13"}
+{"hsqls":["SELECT TailNum, DivTailNums__MV0, DivTailNums__MV1, DivTailNums__MV2, DivTailNums__MV3, DivTailNums__MV4 FROM mytable WHERE (DivWheelsOns__MV0 <= 1937 OR DivWheelsOns__MV1 <= 1937 OR DivWheelsOns__MV2 <= 1937 OR DivWheelsOns__MV3 <= 1937 OR DivWheelsOns__MV4 <= 1937) OR DepartureDelayGroups < 7 LIMIT 10000"],"pql":"SELECT TailNum, DivTailNums FROM mytable WHERE DivWheelsOns <= 1937 OR DepartureDelayGroups < 7 LIMIT 27"}
+{"hsqls":["SELECT TaxiIn, WheelsOn FROM mytable WHERE OriginState > 'HI' AND DaysSinceEpoch < 16078 LIMIT 10000"],"pql":"SELECT TaxiIn, WheelsOn FROM mytable WHERE OriginState > 'HI' AND DaysSinceEpoch < 16078 LIMIT 19"}
+{"hsqls":["SELECT TaxiOut FROM mytable WHERE ArrTime BETWEEN 1921 AND 2327 LIMIT 10000"],"pql":"SELECT TaxiOut FROM mytable WHERE ArrTime BETWEEN 1921 AND 2327 LIMIT 23"}
+{"hsqls":["SELECT TaxiOut, Carrier, ArrivalDelayGroups FROM mytable WHERE Month IN (1) AND DivArrDelay BETWEEN 362 AND 399 OR TailNum NOT IN ('N266WN', 'N3GVAA', 'N593JB') LIMIT 10000"],"pql":"SELECT TaxiOut, Carrier, ArrivalDelayGroups FROM mytable WHERE Month IN (1) AND DivArrDelay BETWEEN 362 AND 399 OR TailNum NOT IN ('N266WN', 'N3GVAA', 'N593JB') LIMIT 20"}
+{"hsqls":["SELECT TotalAddGTime, DivAirportIDs__MV0, DivAirportIDs__MV1, DivAirportIDs__MV2, DivAirportIDs__MV3, DivAirportIDs__MV4 FROM mytable WHERE Quarter BETWEEN 1 AND 1 AND Quarter IN (1) LIMIT 10000"],"pql":"SELECT TotalAddGTime, DivAirportIDs FROM mytable WHERE Quarter BETWEEN 1 AND 1 AND Quarter IN (1) LIMIT 21"}
+{"hsqls":["SELECT TotalAddGTime, DivTailNums__MV0, DivTailNums__MV1, DivTailNums__MV2, DivTailNums__MV3, DivTailNums__MV4, UniqueCarrier FROM mytable WHERE Distance BETWEEN 978 AND 1092 OR DestAirportID = 13388 OR OriginStateFips BETWEEN 6 AND 5 LIMIT 10000"],"pql":"SELECT TotalAddGTime, DivTailNums, UniqueCarrier FROM mytable WHERE Distance BETWEEN 978 AND 1092 OR DestAirportID = 13388 OR OriginStateFips BETWEEN 6 AND 5 LIMIT 4"}
+{"hsqls":["SELECT UniqueCarrier FROM mytable LIMIT 10000"],"pql":"SELECT UniqueCarrier FROM mytable LIMIT 5"}
+{"hsqls":["SELECT WeatherDelay, TaxiIn, AirTime FROM mytable LIMIT 10000"],"pql":"SELECT WeatherDelay, TaxiIn, AirTime FROM mytable LIMIT 19"}
+{"hsqls":["SELECT WheelsOff, WeatherDelay FROM mytable WHERE LongestAddGTime BETWEEN 8 AND 15 OR TailNum <= 'N905SW' LIMIT 10000"],"pql":"SELECT WheelsOff, WeatherDelay FROM mytable WHERE LongestAddGTime BETWEEN 8 AND 15 OR TailNum <= 'N905SW' LIMIT 24"}
+{"hsqls":["SELECT WheelsOn FROM mytable WHERE CarrierDelay IN (26) AND WheelsOff IN (2019, 829, 1956) LIMIT 10000"],"pql":"SELECT WheelsOn FROM mytable WHERE CarrierDelay IN (26) AND WheelsOff IN (2019, 829, 1956) LIMIT 2"}
+{"hsqls":["SELECT Year FROM mytable WHERE DaysSinceEpoch IN (16098, 16097, 16093) AND TotalAddGTime NOT IN (94) AND TaxiOut IN (3, 5, 81, 102, 73) LIMIT 10000"],"pql":"SELECT Year FROM mytable WHERE DaysSinceEpoch IN (16098, 16097, 16093) AND TotalAddGTime NOT IN (94) AND TaxiOut IN (3, 5, 81, 102, 73) LIMIT 23"}
+{"hsqls":["SELECT Year, Quarter FROM mytable WHERE DestCityMarketID NOT IN (34960, 33316, 33127, 31973, 32982) LIMIT 10000"],"pql":"SELECT Year, Quarter FROM mytable WHERE DestCityMarketID NOT IN (34960, 33316, 33127, 31973, 32982) LIMIT 19"}
+
+# Selection & Order by
+{"hsqls":["SELECT ActualElapsedTime FROM mytable ORDER BY ActualElapsedTime, DestCityName LIMIT 10000"],"pql":"SELECT ActualElapsedTime FROM mytable ORDER BY ActualElapsedTime, DestCityName LIMIT 25"}
+{"hsqls":["SELECT ActualElapsedTime, UniqueCarrier FROM mytable WHERE Distance BETWEEN 2288 AND 3711 ORDER BY DestStateFips, SecurityDelay, CancellationCode LIMIT 10000"],"pql":"SELECT ActualElapsedTime, UniqueCarrier FROM mytable WHERE Distance BETWEEN 2288 AND 3711 ORDER BY DestStateFips, SecurityDelay, CancellationCode LIMIT 26"}
+{"hsqls":["SELECT AirTime, AirlineID FROM mytable WHERE Distance BETWEEN 365 AND 1774 OR DepTimeBlk NOT IN ('1600-1659', '2000-2059', '1300-1359', '2300-2359') OR AirlineID < 19790 ORDER BY DepDelay, DepTime, Cancelled LIMIT 10000"],"pql":"SELECT AirTime, AirlineID FROM mytable WHERE Distance BETWEEN 365 AND 1774 OR DepTimeBlk NOT IN ('1600-1659', '2000-2059', '1300-1359', '2300-2359') OR AirlineID < 19790 ORDER BY DepDelay, DepTime, Cancelled LIMIT 16"}
+{"hsqls":["SELECT CRSArrTime FROM mytable WHERE (DivTailNums__MV0 BETWEEN 'N73445' AND 'N766JB' OR DivTailNums__MV1 BETWEEN 'N73445' AND 'N766JB' OR DivTailNums__MV2 BETWEEN 'N73445' AND 'N766JB' OR DivTailNums__MV3 BETWEEN 'N73445' AND 'N766JB' OR DivTailNums__MV4 BETWEEN 'N73445' AND 'N766JB') AND Month BETWEEN 1 AND 1 OR DivDistance NOT IN (151, 575, 71, 972) ORDER BY OriginAirportSeqID, DepDelay, UniqueCarrier LIMIT 10000"],"pql":"SELECT CRSArrTime FROM mytable WHERE DivTailNums BETW [...]
+{"hsqls":["SELECT CRSArrTime FROM mytable WHERE ArrDel15 BETWEEN 0 AND 0 OR DivActualElapsedTime IN (989, 387, 847) AND Quarter < 1 ORDER BY DepTimeBlk LIMIT 10000"],"pql":"SELECT CRSArrTime FROM mytable WHERE ArrDel15 BETWEEN 0 AND 0 OR DivActualElapsedTime IN (989, 387, 847) AND Quarter < 1 ORDER BY DepTimeBlk LIMIT 12"}
+{"hsqls":["SELECT CRSElapsedTime, DaysSinceEpoch FROM mytable WHERE DepartureDelayGroups IN (2, 5) ORDER BY Year, LateAircraftDelay LIMIT 10000"],"pql":"SELECT CRSElapsedTime, DaysSinceEpoch FROM mytable WHERE DepartureDelayGroups IN (2, 5) ORDER BY Year, LateAircraftDelay LIMIT 11"}
+{"hsqls":["SELECT CancellationCode FROM mytable WHERE WheelsOff < 2056 AND DepTimeBlk <= '2000-2059' ORDER BY DestStateName LIMIT 10000"],"pql":"SELECT CancellationCode FROM mytable WHERE WheelsOff < 2056 AND DepTimeBlk <= '2000-2059' ORDER BY DestStateName LIMIT 24"}
+{"hsqls":["SELECT Carrier, ActualElapsedTime, UniqueCarrier FROM mytable ORDER BY OriginState, DivAirportLandings, WheelsOn LIMIT 10000"],"pql":"SELECT Carrier, ActualElapsedTime, UniqueCarrier FROM mytable ORDER BY OriginState, DivAirportLandings, WheelsOn LIMIT 28"}
+{"hsqls":["SELECT CarrierDelay FROM mytable WHERE ArrDelay NOT IN (157.0, 108.0, 996.0, 463.0) ORDER BY ActualElapsedTime, DestCityName, DestAirportID LIMIT 10000"],"pql":"SELECT CarrierDelay FROM mytable WHERE ArrDelay NOT IN (157.0, 108.0, 996.0, 463.0) ORDER BY ActualElapsedTime, DestCityName, DestAirportID LIMIT 10"}
+{"hsqls":["SELECT DayOfWeek FROM mytable WHERE OriginStateName BETWEEN 'Ohio' AND 'Virginia' OR OriginCityMarketID BETWEEN 34057 AND 32016 OR CRSDepTime < 947 ORDER BY DivDistance, DepDelayMinutes, DayofMonth LIMIT 10000"],"pql":"SELECT DayOfWeek FROM mytable WHERE OriginStateName BETWEEN 'Ohio' AND 'Virginia' OR OriginCityMarketID BETWEEN 34057 AND 32016 OR CRSDepTime < 947 ORDER BY DivDistance, DepDelayMinutes, DayofMonth LIMIT 19"}
+{"hsqls":["SELECT DayofMonth FROM mytable ORDER BY Cancelled, DestStateName LIMIT 10000"],"pql":"SELECT DayofMonth FROM mytable ORDER BY Cancelled, DestStateName LIMIT 26"}
+{"hsqls":["SELECT DaysSinceEpoch FROM mytable WHERE DepartureDelayGroups >= -1 AND (DivWheelsOns__MV0 BETWEEN 938 AND 1127 OR DivWheelsOns__MV1 BETWEEN 938 AND 1127 OR DivWheelsOns__MV2 BETWEEN 938 AND 1127 OR DivWheelsOns__MV3 BETWEEN 938 AND 1127 OR DivWheelsOns__MV4 BETWEEN 938 AND 1127) AND DestAirportID <= 11778 ORDER BY OriginStateFips, LongestAddGTime LIMIT 10000"],"pql":"SELECT DaysSinceEpoch FROM mytable WHERE DepartureDelayGroups >= -1 AND DivWheelsOns BETWEEN 938 AND 1127 AND [...]
+{"hsqls":["SELECT DepDel15 FROM mytable WHERE (DivAirportSeqIDs__MV0 BETWEEN 1066602 AND 1291503 OR DivAirportSeqIDs__MV1 BETWEEN 1066602 AND 1291503 OR DivAirportSeqIDs__MV2 BETWEEN 1066602 AND 1291503 OR DivAirportSeqIDs__MV3 BETWEEN 1066602 AND 1291503 OR DivAirportSeqIDs__MV4 BETWEEN 1066602 AND 1291503) ORDER BY DepDel15, Month LIMIT 10000"],"pql":"SELECT DepDel15 FROM mytable WHERE DivAirportSeqIDs BETWEEN 1066602 AND 1291503 ORDER BY DepDel15, Month LIMIT 7"}
+{"hsqls":["SELECT DepDelay, TotalAddGTime, Origin FROM mytable WHERE CRSArrTime > 942 OR OriginAirportID < 11076 ORDER BY FlightDate, DestCityMarketID LIMIT 10000"],"pql":"SELECT DepDelay, TotalAddGTime, Origin FROM mytable WHERE CRSArrTime > 942 OR OriginAirportID < 11076 ORDER BY FlightDate, DestCityMarketID LIMIT 21"}
+{"hsqls":["SELECT DepDelayMinutes, LongestAddGTime FROM mytable WHERE WheelsOff <= 2300 ORDER BY LongestAddGTime, ArrTime, Cancelled LIMIT 10000"],"pql":"SELECT DepDelayMinutes, LongestAddGTime FROM mytable WHERE WheelsOff <= 2300 ORDER BY LongestAddGTime, ArrTime, Cancelled LIMIT 8"}
+{"hsqls":["SELECT DepTime FROM mytable WHERE Year NOT IN (2014) OR (DivAirportSeqIDs__MV0 <= 1129202 OR DivAirportSeqIDs__MV1 <= 1129202 OR DivAirportSeqIDs__MV2 <= 1129202 OR DivAirportSeqIDs__MV3 <= 1129202 OR DivAirportSeqIDs__MV4 <= 1129202) OR TaxiIn BETWEEN 3 AND 24 ORDER BY Carrier, FlightNum LIMIT 10000"],"pql":"SELECT DepTime FROM mytable WHERE Year NOT IN (2014) OR DivAirportSeqIDs <= 1129202 OR TaxiIn BETWEEN 3 AND 24 ORDER BY Carrier, FlightNum LIMIT 10"}
+{"hsqls":["SELECT DepTime, AirlineID FROM mytable WHERE ArrDelay BETWEEN 83.0 AND 269.0 OR DivAirportLandings BETWEEN 1 AND 9 ORDER BY DepartureDelayGroups, Carrier LIMIT 10000"],"pql":"SELECT DepTime, AirlineID FROM mytable WHERE ArrDelay BETWEEN 83.0 AND 269.0 OR DivAirportLandings BETWEEN 1 AND 9 ORDER BY DepartureDelayGroups, Carrier LIMIT 12"}
+{"hsqls":["SELECT DepTimeBlk, ArrDelay FROM mytable WHERE CRSDepTime >= 1124 AND OriginState IN ('ND', 'CA', 'WA', 'AK', 'WI') ORDER BY LateAircraftDelay LIMIT 10000"],"pql":"SELECT DepTimeBlk, ArrDelay FROM mytable WHERE CRSDepTime >= 1124 AND OriginState IN ('ND', 'CA', 'WA', 'AK', 'WI') ORDER BY LateAircraftDelay LIMIT 21"}
+{"hsqls":["SELECT DepartureDelayGroups FROM mytable WHERE DestStateFips BETWEEN 22 AND 31 ORDER BY TailNum, DepTimeBlk, Month LIMIT 10000"],"pql":"SELECT DepartureDelayGroups FROM mytable WHERE DestStateFips BETWEEN 22 AND 31 ORDER BY TailNum, DepTimeBlk, Month LIMIT 16"}
+{"hsqls":["SELECT DivAirports__MV0, DivAirports__MV1, DivAirports__MV2, DivAirports__MV3, DivAirports__MV4 FROM mytable WHERE DepDelayMinutes BETWEEN 83.0 AND 253.0 OR (DivWheelsOns__MV0 IN (2146, 1808, 1235) OR DivWheelsOns__MV1 IN (2146, 1808, 1235) OR DivWheelsOns__MV2 IN (2146, 1808, 1235) OR DivWheelsOns__MV3 IN (2146, 1808, 1235) OR DivWheelsOns__MV4 IN (2146, 1808, 1235)) OR OriginAirportID IN (13158, 10874) ORDER BY DepDelay, UniqueCarrier LIMIT 10000"],"pql":"SELECT DivAirports [...]
+{"hsqls":["SELECT DivReachedDest, CarrierDelay, WheelsOn FROM mytable ORDER BY OriginCityMarketID, OriginCityName, DaysSinceEpoch LIMIT 10000"],"pql":"SELECT DivReachedDest, CarrierDelay, WheelsOn FROM mytable ORDER BY OriginCityMarketID, OriginCityName, DaysSinceEpoch LIMIT 20"}
+{"hsqls":["SELECT DivTotalGTimes__MV0, DivTotalGTimes__MV1, DivTotalGTimes__MV2, DivTotalGTimes__MV3, DivTotalGTimes__MV4, OriginStateName FROM mytable WHERE OriginStateFips IN (21, 53) ORDER BY NASDelay, Month, OriginStateName LIMIT 10000"],"pql":"SELECT DivTotalGTimes, OriginStateName FROM mytable WHERE OriginStateFips IN (21, 53) ORDER BY NASDelay, Month, OriginStateName LIMIT 16"}
+{"hsqls":["SELECT DivWheelsOffs__MV0, DivWheelsOffs__MV1, DivWheelsOffs__MV2, DivWheelsOffs__MV3, DivWheelsOffs__MV4 FROM mytable ORDER BY ArrDelay LIMIT 10000"],"pql":"SELECT DivWheelsOffs FROM mytable ORDER BY ArrDelay LIMIT 6"}
+{"hsqls":["SELECT FirstDepTime FROM mytable WHERE TaxiOut IN (97, 138, 41, 22) AND DestWac BETWEEN 74 AND 52 OR CarrierDelay > 38 ORDER BY FlightNum, Cancelled, DivArrDelay LIMIT 10000"],"pql":"SELECT FirstDepTime FROM mytable WHERE TaxiOut IN (97, 138, 41, 22) AND DestWac BETWEEN 74 AND 52 OR CarrierDelay > 38 ORDER BY FlightNum, Cancelled, DivArrDelay LIMIT 4"}
+{"hsqls":["SELECT FlightDate, TotalAddGTime, DestCityName FROM mytable ORDER BY DestState, NASDelay, CancellationCode LIMIT 10000"],"pql":"SELECT FlightDate, TotalAddGTime, DestCityName FROM mytable ORDER BY DestState, NASDelay, CancellationCode LIMIT 21"}
+{"hsqls":["SELECT FlightNum FROM mytable WHERE AirlineID BETWEEN 20409 AND 19690 OR DepDelay BETWEEN 62.0 AND 287.0 OR DistanceGroup <> 6 ORDER BY WeatherDelay, SecurityDelay, NASDelay LIMIT 10000"],"pql":"SELECT FlightNum FROM mytable WHERE AirlineID BETWEEN 20409 AND 19690 OR DepDelay BETWEEN 62.0 AND 287.0 OR DistanceGroup <> 6 ORDER BY WeatherDelay, SecurityDelay, NASDelay LIMIT 3"}
+{"hsqls":["SELECT Flights FROM mytable WHERE ArrTime > 919 ORDER BY CarrierDelay LIMIT 10000"],"pql":"SELECT Flights FROM mytable WHERE ArrTime > 919 ORDER BY CarrierDelay LIMIT 4"}
+{"hsqls":["SELECT LateAircraftDelay FROM mytable WHERE DayOfWeek IN (3, 2, 1, 4) AND DestWac IN (44) ORDER BY OriginStateFips LIMIT 10000"],"pql":"SELECT LateAircraftDelay FROM mytable WHERE DayOfWeek IN (3, 2, 1, 4) AND DestWac IN (44) ORDER BY OriginStateFips LIMIT 14"}
+{"hsqls":["SELECT NASDelay FROM mytable WHERE (DivAirportSeqIDs__MV0 BETWEEN 1052103 AND 1233904 OR DivAirportSeqIDs__MV1 BETWEEN 1052103 AND 1233904 OR DivAirportSeqIDs__MV2 BETWEEN 1052103 AND 1233904 OR DivAirportSeqIDs__MV3 BETWEEN 1052103 AND 1233904 OR DivAirportSeqIDs__MV4 BETWEEN 1052103 AND 1233904) OR ActualElapsedTime >= 173 AND NASDelay BETWEEN 68 AND 78 ORDER BY DepTime LIMIT 10000"],"pql":"SELECT NASDelay FROM mytable WHERE DivAirportSeqIDs BETWEEN 1052103 AND 1233904 OR Ac [...]
+{"hsqls":["SELECT Origin FROM mytable WHERE (DivAirportIDs__MV0 = 13198 OR DivAirportIDs__MV1 = 13198 OR DivAirportIDs__MV2 = 13198 OR DivAirportIDs__MV3 = 13198 OR DivAirportIDs__MV4 = 13198) ORDER BY OriginAirportSeqID, DistanceGroup, DestCityMarketID LIMIT 10000"],"pql":"SELECT Origin FROM mytable WHERE DivAirportIDs = 13198 ORDER BY OriginAirportSeqID, DistanceGroup, DestCityMarketID LIMIT 7"}
+{"hsqls":["SELECT OriginStateName FROM mytable WHERE DestWac BETWEEN 91 AND 91 ORDER BY ActualElapsedTime, AirlineID, DayOfWeek LIMIT 10000"],"pql":"SELECT OriginStateName FROM mytable WHERE DestWac BETWEEN 91 AND 91 ORDER BY ActualElapsedTime, AirlineID, DayOfWeek LIMIT 1"}
+{"hsqls":["SELECT OriginWac FROM mytable WHERE DestStateFips BETWEEN 4 AND 28 OR CRSElapsedTime <= 455 AND (DivAirportSeqIDs__MV0 > 1509602 OR DivAirportSeqIDs__MV1 > 1509602 OR DivAirportSeqIDs__MV2 > 1509602 OR DivAirportSeqIDs__MV3 > 1509602 OR DivAirportSeqIDs__MV4 > 1509602) ORDER BY LongestAddGTime LIMIT 10000"],"pql":"SELECT OriginWac FROM mytable WHERE DestStateFips BETWEEN 4 AND 28 OR CRSElapsedTime <= 455 AND DivAirportSeqIDs > 1509602 ORDER BY LongestAddGTime LIMIT 11"}
+{"hsqls":["SELECT Quarter, CarrierDelay, DivTotalGTimes__MV0, DivTotalGTimes__MV1, DivTotalGTimes__MV2, DivTotalGTimes__MV3, DivTotalGTimes__MV4 FROM mytable WHERE Distance < 335 OR Dest BETWEEN 'JAX' AND 'DBQ' ORDER BY UniqueCarrier LIMIT 10000"],"pql":"SELECT Quarter, CarrierDelay, DivTotalGTimes FROM mytable WHERE Distance < 335 OR Dest BETWEEN 'JAX' AND 'DBQ' ORDER BY UniqueCarrier LIMIT 28"}
+{"hsqls":["SELECT SecurityDelay, TaxiIn, DivActualElapsedTime FROM mytable WHERE CarrierDelay BETWEEN 21 AND 157 ORDER BY FlightDate, WheelsOn LIMIT 10000"],"pql":"SELECT SecurityDelay, TaxiIn, DivActualElapsedTime FROM mytable WHERE CarrierDelay BETWEEN 21 AND 157 ORDER BY FlightDate, WheelsOn LIMIT 28"}
+{"hsqls":["SELECT TailNum, UniqueCarrier, OriginAirportID FROM mytable ORDER BY DivArrDelay LIMIT 10000"],"pql":"SELECT TailNum, UniqueCarrier, OriginAirportID FROM mytable ORDER BY DivArrDelay LIMIT 8"}
+{"hsqls":["SELECT TaxiIn, DivArrDelay, DaysSinceEpoch FROM mytable WHERE DivActualElapsedTime > 372 AND ArrDelayMinutes <> 60.0 OR TaxiIn BETWEEN 22 AND 84 ORDER BY Year, LongestAddGTime, ActualElapsedTime LIMIT 10000"],"pql":"SELECT TaxiIn, DivArrDelay, DaysSinceEpoch FROM mytable WHERE DivActualElapsedTime > 372 AND ArrDelayMinutes <> 60.0 OR TaxiIn BETWEEN 22 AND 84 ORDER BY Year, LongestAddGTime, ActualElapsedTime LIMIT 6"}
+{"hsqls":["SELECT TaxiOut, DepDel15, WheelsOn FROM mytable WHERE (DivAirportIDs__MV0 IN (11278, 10521, 10754) OR DivAirportIDs__MV1 IN (11278, 10521, 10754) OR DivAirportIDs__MV2 IN (11278, 10521, 10754) OR DivAirportIDs__MV3 IN (11278, 10521, 10754) OR DivAirportIDs__MV4 IN (11278, 10521, 10754)) OR WheelsOff > 2032 AND TaxiIn IN (30, 94, 47, 27, 28) ORDER BY DestCityMarketID LIMIT 10000"],"pql":"SELECT TaxiOut, DepDel15, WheelsOn FROM mytable WHERE DivAirportIDs IN (11278, 10521, 10754 [...]
+{"hsqls":["SELECT UniqueCarrier FROM mytable WHERE (DivAirports__MV0 IN ('MSO') OR DivAirports__MV1 IN ('MSO') OR DivAirports__MV2 IN ('MSO') OR DivAirports__MV3 IN ('MSO') OR DivAirports__MV4 IN ('MSO')) OR OriginState IN ('CA') AND ArrTimeBlk <> '2200-2259' ORDER BY Origin, DivActualElapsedTime LIMIT 10000"],"pql":"SELECT UniqueCarrier FROM mytable WHERE DivAirports IN ('MSO') OR OriginState IN ('CA') AND ArrTimeBlk <> '2200-2259' ORDER BY Origin, DivActualElapsedTime LIMIT 18"}
+{"hsqls":["SELECT UniqueCarrier FROM mytable WHERE (DivTotalGTimes__MV0 BETWEEN 84 AND 50 OR DivTotalGTimes__MV1 BETWEEN 84 AND 50 OR DivTotalGTimes__MV2 BETWEEN 84 AND 50 OR DivTotalGTimes__MV3 BETWEEN 84 AND 50 OR DivTotalGTimes__MV4 BETWEEN 84 AND 50) OR OriginStateName IN ('Missouri') ORDER BY WheelsOff, DepTimeBlk LIMIT 10000"],"pql":"SELECT UniqueCarrier FROM mytable WHERE DivTotalGTimes BETWEEN 84 AND 50 OR OriginStateName IN ('Missouri') ORDER BY WheelsOff, DepTimeBlk LIMIT 26"}
+{"hsqls":["SELECT WeatherDelay FROM mytable WHERE Year > 2014 OR DepTime NOT IN (1031, 1447, 2343, 1557, 821) ORDER BY ArrTime LIMIT 10000"],"pql":"SELECT WeatherDelay FROM mytable WHERE Year > 2014 OR DepTime NOT IN (1031, 1447, 2343, 1557, 821) ORDER BY ArrTime LIMIT 27"}
+{"hsqls":["SELECT WheelsOff, Year, Carrier FROM mytable WHERE Year BETWEEN 2014 AND 2014 AND DayofMonth NOT IN (1, 31, 28) OR DestAirportID IN (10299, 11996, 13424, 11982) ORDER BY DestWac LIMIT 10000"],"pql":"SELECT WheelsOff, Year, Carrier FROM mytable WHERE Year BETWEEN 2014 AND 2014 AND DayofMonth NOT IN (1, 31, 28) OR DestAirportID IN (10299, 11996, 13424, 11982) ORDER BY DestWac LIMIT 9"}
+{"hsqls":["SELECT WheelsOn FROM mytable ORDER BY CRSArrTime, NASDelay, OriginWac LIMIT 10000"],"pql":"SELECT WheelsOn FROM mytable ORDER BY CRSArrTime, NASDelay, OriginWac LIMIT 19"}
+{"hsqls":["SELECT Year FROM mytable WHERE NASDelay < 42 AND Cancelled BETWEEN 0 AND 0 AND DestCityName IN ('Las Vegas, NV', 'Laramie, WY', 'Brownsville, TX', 'Klamath Falls, OR', 'Palm Springs, CA') ORDER BY DepDelay, DestStateFips, OriginStateName LIMIT 10000"],"pql":"SELECT Year FROM mytable WHERE NASDelay < 42 AND Cancelled BETWEEN 0 AND 0 AND DestCityName IN ('Las Vegas, NV', 'Laramie, WY', 'Brownsville, TX', 'Klamath Falls, OR', 'Palm Springs, CA') ORDER BY DepDelay, DestStateFips, [...]
+{"hsqls":["SELECT Year FROM mytable WHERE WheelsOff IN (2030) AND DivActualElapsedTime BETWEEN 485 AND 336 OR Origin <= 'PHF' ORDER BY SecurityDelay LIMIT 10000"],"pql":"SELECT Year FROM mytable WHERE WheelsOff IN (2030) AND DivActualElapsedTime BETWEEN 485 AND 336 OR Origin <= 'PHF' ORDER BY SecurityDelay LIMIT 3"}
+{"hsqls":["SELECT Year, DivDistance, Dest FROM mytable WHERE AirlineID NOT IN (20304, 21171) OR WheelsOff IN (1513, 1033, 700, 2325, 1922) OR OriginAirportID BETWEEN 12156 AND 15919 ORDER BY OriginState LIMIT 10000"],"pql":"SELECT Year, DivDistance, Dest FROM mytable WHERE AirlineID NOT IN (20304, 21171) OR WheelsOff IN (1513, 1033, 700, 2325, 1922) OR OriginAirportID BETWEEN 12156 AND 15919 ORDER BY OriginState LIMIT 10"}
+{"hsqls":["SELECT Year, WeatherDelay, ArrDel15 FROM mytable WHERE Diverted IN (1, 0) OR DayofMonth >= 9 OR DestStateName <> 'North Carolina' ORDER BY OriginAirportSeqID LIMIT 10000"],"pql":"SELECT Year, WeatherDelay, ArrDel15 FROM mytable WHERE Diverted IN (1, 0) OR DayofMonth >= 9 OR DestStateName <> 'North Carolina' ORDER BY OriginAirportSeqID LIMIT 6"}
+
+# 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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org